APPS.PAYUSUNB_PKG dependencies on PAY_RUN_BALANCES

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

169: G_commit_count NUMBER := NULL;
170:
171: -- Global values to store the flag based on the validity of
172: -- the corresponding balances i.e., IF G_state_flag := 'Y' then
173: -- all state balances are valid in pay_run_balances
174: -- else atleast one of the state balance is invalid
175: G_state_flag VARCHAR2(1);
176: G_county_flag VARCHAR2(1);
177: G_city_flag VARCHAR2(1);

Line 1858: FROM pay_run_balances prb,

1854: SELECT DISTINCT
1855: prb.jurisdiction_code||'-000-0000' jurisdiction_code,
1856: pus.state_code state_code,
1857: pus.state_abbrev
1858: FROM pay_run_balances prb,
1859: per_assignments_f paf,
1860: pay_us_states pus
1861: WHERE paf.person_id = IN_person_id
1862: AND prb.effective_date BETWEEN IN_start_date and IN_as_of_date

Line 1879: FROM pay_run_balances prb,

1875: IN_as_of_date IN DATE) IS
1876: SELECT DISTINCT
1877: prb.jurisdiction_code||'-0000' jurisdiction_code,
1878: puc.county_name||','||pus.state_abbrev jurisdiction_name
1879: FROM pay_run_balances prb,
1880: per_assignments_f paf,
1881: pay_us_states pus,
1882: pay_us_counties puc
1883: WHERE paf.person_id = IN_person_id

Line 1905: FROM pay_run_balances prb,

1901: IN_as_of_date IN DATE) IS
1902: SELECT DISTINCT
1903: prb.jurisdiction_code,
1904: pun.city_name||','||pus.state_abbrev jurisdiction_name
1905: FROM pay_run_balances prb,
1906: per_assignments_f paf,
1907: pay_us_states pus,
1908: pay_us_city_names pun
1909: WHERE paf.person_id = IN_person_id

Line 1937: FROM pay_run_balances prb,

1933: SELECT DISTINCT
1934: prb.jurisdiction_code,
1935: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1936: psd.state_code||'-'||psd.county_code||'-'||psd.city_code reg_jurisdiction_cd
1937: FROM pay_run_balances prb,
1938: per_assignments_f paf,
1939: pay_us_states pus,
1940: pay_us_city_school_dsts psd
1941: WHERE paf.person_id = IN_person_id

Line 1961: pay_run_balances prb,

1957: prb.jurisdiction_code,
1958: psd.school_dst_name||','||pus.state_abbrev jurisdiction_name,
1959: psd.state_code||'-'||psd.county_code||'-0000' reg_jurisdiction_cd
1960: FROM per_assignments_f paf,
1961: pay_run_balances prb,
1962: pay_us_states pus,
1963: pay_us_county_school_dsts psd
1964: WHERE paf.person_id = IN_person_id
1965: AND paf.effective_start_date <= IN_as_of_date