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

1681: SELECT run_type_id parent_id
1682: FROM pay_run_types_f
1683: WHERE (run_type_name,shortname) IN (SELECT RUN_TYPE_NAME, shortname from pay_run_types_f
1684: WHERE RUN_TYPE_ID IN (SELECT PARENT_RUN_TYPE_ID
1685: FROM pay_run_type_usages_f
1686: WHERE LEGISLATION_CODE = 'ZZ'
1687: AND sysdate BETWEEN EFFECTIVE_START_DATE
1688: AND EFFECTIVE_END_DATE
1689: AND business_group_id is null

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

1696: AND business_group_id is NULL;
1697:
1698: Cursor run_type_child_csr (l_legislation_code IN VARCHAR2) IS
1699: SELECT prtf1.run_type_id child_id , prtuf.sequence sequence , prtf1.run_type_name run_type_name
1700: FROM pay_run_types_f prtf1, pay_run_types_f prtf2 , pay_run_type_usages_f prtuf
1701: WHERE (prtf1.run_type_name,prtf1.shortname) IN (SELECT RUN_TYPE_NAME, shortname
1702: FROM pay_run_types_f
1703: WHERE RUN_TYPE_ID IN (SELECT child_RUN_TYPE_ID
1704: FROM pay_run_type_usages_f

Line 1704: FROM pay_run_type_usages_f

1700: FROM pay_run_types_f prtf1, pay_run_types_f prtf2 , pay_run_type_usages_f prtuf
1701: WHERE (prtf1.run_type_name,prtf1.shortname) IN (SELECT RUN_TYPE_NAME, shortname
1702: FROM pay_run_types_f
1703: WHERE RUN_TYPE_ID IN (SELECT child_RUN_TYPE_ID
1704: FROM pay_run_type_usages_f
1705: WHERE parent_run_type_id in (SELECT distinct PARENT_RUN_TYPE_ID
1706: FROM pay_run_type_usages_f
1707: WHERE LEGISLATION_CODE = 'ZZ'
1708: AND sysdate BETWEEN EFFECTIVE_START_DATE

Line 1706: FROM pay_run_type_usages_f

1702: FROM pay_run_types_f
1703: WHERE RUN_TYPE_ID IN (SELECT child_RUN_TYPE_ID
1704: FROM pay_run_type_usages_f
1705: WHERE parent_run_type_id in (SELECT distinct PARENT_RUN_TYPE_ID
1706: FROM pay_run_type_usages_f
1707: WHERE LEGISLATION_CODE = 'ZZ'
1708: AND sysdate BETWEEN EFFECTIVE_START_DATE
1709: AND EFFECTIVE_END_DATE
1710: AND business_group_id is null)

Line 1739: l_rtu_id pay_run_type_usages_f.run_type_usage_id%TYPE;

1735: l_rt_eff_end_date pay_run_types_f.effective_end_date%TYPE;
1736:
1737: --local variables for Run Type Usages
1738:
1739: l_rtu_id pay_run_type_usages_f.run_type_usage_id%TYPE;
1740: l_rtu_ovn pay_run_type_usages_f.object_version_number%TYPE;
1741: l_rtu_eff_start_date pay_run_type_usages_f.effective_start_date%TYPE;
1742: l_rtu_eff_end_date pay_run_type_usages_f.effective_end_date%TYPE;
1743: l_process VARCHAR2(100);

Line 1740: l_rtu_ovn pay_run_type_usages_f.object_version_number%TYPE;

1736:
1737: --local variables for Run Type Usages
1738:
1739: l_rtu_id pay_run_type_usages_f.run_type_usage_id%TYPE;
1740: l_rtu_ovn pay_run_type_usages_f.object_version_number%TYPE;
1741: l_rtu_eff_start_date pay_run_type_usages_f.effective_start_date%TYPE;
1742: l_rtu_eff_end_date pay_run_type_usages_f.effective_end_date%TYPE;
1743: l_process VARCHAR2(100);
1744:

Line 1741: l_rtu_eff_start_date pay_run_type_usages_f.effective_start_date%TYPE;

1737: --local variables for Run Type Usages
1738:
1739: l_rtu_id pay_run_type_usages_f.run_type_usage_id%TYPE;
1740: l_rtu_ovn pay_run_type_usages_f.object_version_number%TYPE;
1741: l_rtu_eff_start_date pay_run_type_usages_f.effective_start_date%TYPE;
1742: l_rtu_eff_end_date pay_run_type_usages_f.effective_end_date%TYPE;
1743: l_process VARCHAR2(100);
1744:
1745:

Line 1742: l_rtu_eff_end_date pay_run_type_usages_f.effective_end_date%TYPE;

1738:
1739: l_rtu_id pay_run_type_usages_f.run_type_usage_id%TYPE;
1740: l_rtu_ovn pay_run_type_usages_f.object_version_number%TYPE;
1741: l_rtu_eff_start_date pay_run_type_usages_f.effective_start_date%TYPE;
1742: l_rtu_eff_end_date pay_run_type_usages_f.effective_end_date%TYPE;
1743: l_process VARCHAR2(100);
1744:
1745:
1746: BEGIN

Line 1804: FROM pay_run_type_usages_f

1800:
1801: BEGIN
1802: SELECT run_type_usage_id, object_version_number
1803: INTO l_rtu_id, l_rtu_ovn
1804: FROM pay_run_type_usages_f
1805: WHERE parent_run_type_id = rec_parent.parent_id
1806: AND child_run_type_id = rec_child.child_id
1807: AND legislation_code = p_legislation_code
1808: AND sysdate between effective_start_date and effective_end_date