APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_RUN_TYPES_F_TL

Line 1920: FROM pay_run_types_f_tl t, pay_run_types_f b

1916:
1917: CURSOR get_runid_btable_csr IS
1918: SELECT b.run_type_id bid , b.run_type_name bname,
1919: t.language, t.run_type_name tname, t.shortname, t.source_lang
1920: FROM pay_run_types_f_tl t, pay_run_types_f b
1921: WHERE t.run_type_id = b.run_type_id
1922: AND b.legislation_code = 'ZZ'
1923: AND b.business_group_id IS NULL
1924: AND sysdate BETWEEN b.effective_start_date AND b.effective_end_date ;

Line 1928: FROM pay_run_types_f_tl t, pay_run_types_f b

1924: AND sysdate BETWEEN b.effective_start_date AND b.effective_end_date ;
1925:
1926: CURSOR get_runid_tltable_csr(l_legislation_code VARCHAR2, l_name VARCHAR2, l_language VARCHAR2) IS
1927: SELECT t.run_type_id tlid
1928: FROM pay_run_types_f_tl t, pay_run_types_f b
1929: WHERE b.run_type_name = l_name
1930: AND b.legislation_code = l_legislation_code
1931: AND b.business_group_id IS NULL
1932: AND t.run_type_id = b.run_type_id

Line 1948: UPDATE pay_run_types_f_tl

1944: fetch get_runid_tltable_csr INTO rec_tltable_csr ;
1945:
1946: if get_runid_tltable_csr%found then
1947:
1948: UPDATE pay_run_types_f_tl
1949: SET run_type_name = l_record.tname,
1950: shortname = l_record.shortname,
1951: source_lang = l_record.source_lang
1952: WHERE run_type_id = rec_tltable_csr.tlid