eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_RUN_TYPE_USAGES_F

Line 2186: FROM pay_run_type_usages_f

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
2189: AND EFFECTIVE_END_DATE
2190: AND business_group_id is null

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 2205: FROM pay_run_type_usages_f

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
2208: WHERE LEGISLATION_CODE = 'ZZ'
2209: AND sysdate BETWEEN EFFECTIVE_START_DATE

Line 2207: FROM pay_run_type_usages_f

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
2208: WHERE LEGISLATION_CODE = 'ZZ'
2209: AND sysdate BETWEEN EFFECTIVE_START_DATE
2210: AND EFFECTIVE_END_DATE
2211: AND business_group_id is null)

Line 2240: l_rtu_id pay_run_type_usages_f.run_type_usage_id%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;
2241: l_rtu_ovn pay_run_type_usages_f.object_version_number%TYPE;
2242: l_rtu_eff_start_date pay_run_type_usages_f.effective_start_date%TYPE;
2243: l_rtu_eff_end_date pay_run_type_usages_f.effective_end_date%TYPE;
2244: l_process VARCHAR2(100);

Line 2241: l_rtu_ovn pay_run_type_usages_f.object_version_number%TYPE;

2237:
2238: --local variables for Run Type Usages
2239:
2240: l_rtu_id pay_run_type_usages_f.run_type_usage_id%TYPE;
2241: l_rtu_ovn pay_run_type_usages_f.object_version_number%TYPE;
2242: l_rtu_eff_start_date pay_run_type_usages_f.effective_start_date%TYPE;
2243: l_rtu_eff_end_date pay_run_type_usages_f.effective_end_date%TYPE;
2244: l_process VARCHAR2(100);
2245:

Line 2242: l_rtu_eff_start_date pay_run_type_usages_f.effective_start_date%TYPE;

2238: --local variables for Run Type Usages
2239:
2240: l_rtu_id pay_run_type_usages_f.run_type_usage_id%TYPE;
2241: l_rtu_ovn pay_run_type_usages_f.object_version_number%TYPE;
2242: l_rtu_eff_start_date pay_run_type_usages_f.effective_start_date%TYPE;
2243: l_rtu_eff_end_date pay_run_type_usages_f.effective_end_date%TYPE;
2244: l_process VARCHAR2(100);
2245:
2246:

Line 2243: l_rtu_eff_end_date pay_run_type_usages_f.effective_end_date%TYPE;

2239:
2240: l_rtu_id pay_run_type_usages_f.run_type_usage_id%TYPE;
2241: l_rtu_ovn pay_run_type_usages_f.object_version_number%TYPE;
2242: l_rtu_eff_start_date pay_run_type_usages_f.effective_start_date%TYPE;
2243: l_rtu_eff_end_date pay_run_type_usages_f.effective_end_date%TYPE;
2244: l_process VARCHAR2(100);
2245:
2246:
2247: BEGIN

Line 2305: FROM pay_run_type_usages_f

2301:
2302: BEGIN
2303: SELECT run_type_usage_id, object_version_number
2304: INTO l_rtu_id, l_rtu_ovn
2305: FROM pay_run_type_usages_f
2306: WHERE parent_run_type_id = rec_parent.parent_id
2307: AND child_run_type_id = rec_child.child_id
2308: AND legislation_code = p_legislation_code
2309: AND sysdate between effective_start_date and effective_end_date