APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_RUN_TYPES_F_TL

Line 2421: FROM pay_run_types_f_tl t, pay_run_types_f b

2417:
2418: CURSOR get_runid_btable_csr IS
2419: SELECT b.run_type_id bid , b.run_type_name bname,
2420: t.language, t.run_type_name tname, t.shortname, t.source_lang
2421: FROM pay_run_types_f_tl t, pay_run_types_f b
2422: WHERE t.run_type_id = b.run_type_id
2423: AND b.legislation_code = 'ZZ'
2424: AND b.business_group_id IS NULL
2425: AND sysdate BETWEEN b.effective_start_date AND b.effective_end_date ;

Line 2429: FROM pay_run_types_f_tl t, pay_run_types_f b

2425: AND sysdate BETWEEN b.effective_start_date AND b.effective_end_date ;
2426:
2427: CURSOR get_runid_tltable_csr(l_legislation_code VARCHAR2, l_name VARCHAR2, l_language VARCHAR2) IS
2428: SELECT t.run_type_id tlid
2429: FROM pay_run_types_f_tl t, pay_run_types_f b
2430: WHERE b.run_type_name = l_name
2431: AND b.legislation_code = l_legislation_code
2432: AND b.business_group_id IS NULL
2433: AND t.run_type_id = b.run_type_id

Line 2449: UPDATE pay_run_types_f_tl

2445: fetch get_runid_tltable_csr INTO rec_tltable_csr ;
2446:
2447: if get_runid_tltable_csr%found then
2448:
2449: UPDATE pay_run_types_f_tl
2450: SET run_type_name = l_record.tname,
2451: shortname = l_record.shortname,
2452: source_lang = l_record.source_lang
2453: WHERE run_type_id = rec_tltable_csr.tlid