APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_RUN_TYPES_F

Line 2176: FROM pay_run_types_f

2172: SELECT
2173: run_type_id, run_type_name, run_method, effective_start_date, effective_end_date,
2174: business_group_id, legislation_code, shortname, last_update_date, last_updated_by,
2175: last_update_login, created_by, creation_date, object_version_number
2176: FROM pay_run_types_f
2177: WHERE nvl(legislation_code,'X') = 'ZZ'
2178: AND business_group_id IS NULL and sysdate between effective_start_date and effective_end_date;
2179:
2180:

Line 2183: FROM pay_run_types_f

2179:
2180:
2181: Cursor run_type_parent_csr (l_legislation_code IN VARCHAR2) IS
2182: SELECT run_type_id parent_id
2183: FROM pay_run_types_f
2184: WHERE (run_type_name,shortname) IN (SELECT RUN_TYPE_NAME, shortname from pay_run_types_f
2185: WHERE RUN_TYPE_ID IN (SELECT PARENT_RUN_TYPE_ID
2186: FROM pay_run_type_usages_f
2187: WHERE LEGISLATION_CODE = 'ZZ'

Line 2184: WHERE (run_type_name,shortname) IN (SELECT RUN_TYPE_NAME, shortname from pay_run_types_f

2180:
2181: Cursor run_type_parent_csr (l_legislation_code IN VARCHAR2) IS
2182: SELECT run_type_id parent_id
2183: FROM pay_run_types_f
2184: WHERE (run_type_name,shortname) IN (SELECT RUN_TYPE_NAME, shortname from pay_run_types_f
2185: WHERE RUN_TYPE_ID IN (SELECT PARENT_RUN_TYPE_ID
2186: FROM pay_run_type_usages_f
2187: WHERE LEGISLATION_CODE = 'ZZ'
2188: AND sysdate BETWEEN EFFECTIVE_START_DATE

Line 2201: FROM pay_run_types_f prtf1, pay_run_types_f prtf2 , pay_run_type_usages_f prtuf

2197: AND business_group_id is NULL;
2198:
2199: Cursor run_type_child_csr (l_legislation_code IN VARCHAR2) IS
2200: SELECT prtf1.run_type_id child_id , prtuf.sequence sequence , prtf1.run_type_name run_type_name
2201: FROM pay_run_types_f prtf1, pay_run_types_f prtf2 , pay_run_type_usages_f prtuf
2202: WHERE (prtf1.run_type_name,prtf1.shortname) IN (SELECT RUN_TYPE_NAME, shortname
2203: FROM pay_run_types_f
2204: WHERE RUN_TYPE_ID IN (SELECT child_RUN_TYPE_ID
2205: FROM pay_run_type_usages_f

Line 2203: FROM pay_run_types_f

2199: Cursor run_type_child_csr (l_legislation_code IN VARCHAR2) IS
2200: SELECT prtf1.run_type_id child_id , prtuf.sequence sequence , prtf1.run_type_name run_type_name
2201: FROM pay_run_types_f prtf1, pay_run_types_f prtf2 , pay_run_type_usages_f prtuf
2202: WHERE (prtf1.run_type_name,prtf1.shortname) IN (SELECT RUN_TYPE_NAME, shortname
2203: FROM pay_run_types_f
2204: WHERE RUN_TYPE_ID IN (SELECT child_RUN_TYPE_ID
2205: FROM pay_run_type_usages_f
2206: WHERE parent_run_type_id in (SELECT distinct PARENT_RUN_TYPE_ID
2207: FROM pay_run_type_usages_f

Line 2233: l_rt_id pay_run_types_f.run_type_id%TYPE;

2229:
2230:
2231: --local variables for Run Types
2232:
2233: l_rt_id pay_run_types_f.run_type_id%TYPE;
2234: l_rt_ovn pay_run_types_f.object_version_number%TYPE;
2235: l_rt_eff_start_date pay_run_types_f.effective_start_date%TYPE;
2236: l_rt_eff_end_date pay_run_types_f.effective_end_date%TYPE;
2237:

Line 2234: l_rt_ovn pay_run_types_f.object_version_number%TYPE;

2230:
2231: --local variables for Run Types
2232:
2233: l_rt_id pay_run_types_f.run_type_id%TYPE;
2234: l_rt_ovn pay_run_types_f.object_version_number%TYPE;
2235: l_rt_eff_start_date pay_run_types_f.effective_start_date%TYPE;
2236: l_rt_eff_end_date pay_run_types_f.effective_end_date%TYPE;
2237:
2238: --local variables for Run Type Usages

Line 2235: l_rt_eff_start_date pay_run_types_f.effective_start_date%TYPE;

2231: --local variables for Run Types
2232:
2233: l_rt_id pay_run_types_f.run_type_id%TYPE;
2234: l_rt_ovn pay_run_types_f.object_version_number%TYPE;
2235: l_rt_eff_start_date pay_run_types_f.effective_start_date%TYPE;
2236: l_rt_eff_end_date pay_run_types_f.effective_end_date%TYPE;
2237:
2238: --local variables for Run Type Usages
2239:

Line 2236: l_rt_eff_end_date pay_run_types_f.effective_end_date%TYPE;

2232:
2233: l_rt_id pay_run_types_f.run_type_id%TYPE;
2234: l_rt_ovn pay_run_types_f.object_version_number%TYPE;
2235: l_rt_eff_start_date pay_run_types_f.effective_start_date%TYPE;
2236: l_rt_eff_end_date pay_run_types_f.effective_end_date%TYPE;
2237:
2238: --local variables for Run Type Usages
2239:
2240: l_rtu_id pay_run_type_usages_f.run_type_usage_id%TYPE;

Line 2263: FROM pay_run_types_f

2259:
2260: BEGIN
2261: SELECT run_type_id, object_version_number
2262: INTO l_rt_id, l_rt_ovn
2263: FROM pay_run_types_f
2264: WHERE run_type_name = rec.run_type_name
2265: AND shortname = rec.shortname
2266: AND legislation_code = p_legislation_code
2267: AND sysdate between effective_start_date and effective_end_date

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