APPS.PAYUSUNB_PKG dependencies on PAY_RUN_BALANCES

Line 112: -- all state balances are valid in pay_run_balances

108: G_commit_count NUMBER := NULL;
109:
110: -- Global values to store the flag based on the validity of
111: -- the corresponding balances i.e., IF G_state_flag := 'Y' then
112: -- all state balances are valid in pay_run_balances
113: -- else atleast one of the state balance is invalid
114: G_state_flag VARCHAR2(1);
115: G_county_flag VARCHAR2(1);
116: G_city_flag VARCHAR2(1);

Line 1373: FROM pay_run_balances prb,

1369: SELECT DISTINCT
1370: prb.jurisdiction_code||'-000-0000' jurisdiction_code,
1371: pus.state_code state_code,
1372: pus.state_abbrev
1373: FROM pay_run_balances prb,
1374: per_assignments_f paf,
1375: pay_us_states pus
1376: WHERE paf.person_id = IN_person_id
1377: AND prb.effective_date BETWEEN IN_start_date and IN_as_of_date

Line 1394: FROM pay_run_balances prb,

1390: IN_as_of_date IN DATE) IS
1391: SELECT DISTINCT
1392: prb.jurisdiction_code||'-0000' jurisdiction_code,
1393: puc.county_name||','||pus.state_abbrev jurisdiction_name
1394: FROM pay_run_balances prb,
1395: per_assignments_f paf,
1396: pay_us_states pus,
1397: pay_us_counties puc
1398: WHERE paf.person_id = IN_person_id

Line 1420: FROM pay_run_balances prb,

1416: IN_as_of_date IN DATE) IS
1417: SELECT DISTINCT
1418: prb.jurisdiction_code,
1419: pun.city_name||','||pus.state_abbrev jurisdiction_name
1420: FROM pay_run_balances prb,
1421: per_assignments_f paf,
1422: pay_us_states pus,
1423: pay_us_city_names pun
1424: WHERE paf.person_id = IN_person_id

Line 1452: FROM pay_run_balances prb,

1448: SELECT DISTINCT
1449: prb.jurisdiction_code,
1450: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1451: psd.state_code||'-'||psd.county_code||'-'||psd.city_code reg_jurisdiction_cd
1452: FROM pay_run_balances prb,
1453: per_assignments_f paf,
1454: pay_us_states pus,
1455: pay_us_city_school_dsts psd
1456: WHERE paf.person_id = IN_person_id

Line 1476: pay_run_balances prb,

1472: prb.jurisdiction_code,
1473: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1474: psd.state_code||'-'||psd.county_code||'-0000' reg_jurisdiction_cd
1475: FROM per_assignments_f paf,
1476: pay_run_balances prb,
1477: pay_us_states pus,
1478: pay_us_county_school_dsts psd
1479: WHERE paf.person_id = IN_person_id
1480: AND paf.effective_start_date <= IN_as_of_date