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_DK_HOLIDAY_PAY_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 76: FROM hr_organization_information

72: /* Bug fix 4950983 added org_information1 in select clause */
73: /* Change the to_number to fnd_number.canonical_to_number */
74: CURSOR csr_get_hol_rates(p_org_id NUMBER) is
75: SELECT fnd_number.canonical_to_number(org_information3), fnd_number.canonical_to_number(org_information4), org_information5, org_information1
76: FROM hr_organization_information
77: WHERE organization_id = p_org_id
78: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
79:
80: BEGIN

Line 102: FROM hr_organization_information hoi

98: --
99: CURSOR get_details(p_org_id VARCHAR2) IS
100: SELECT hoi.org_information3
101: , hoi.org_information4
102: FROM hr_organization_information hoi
103: WHERE hoi.org_information_context='DK_EMPLOYMENT_DEFAULTS'
104: AND hoi.organization_id = p_org_id ;
105:
106: --

Line 194: FROM hr_organization_information

190:
191:
192: CURSOR csr_get_le_work_pattern(p_org_id NUMBER) IS
193: SELECT org_information1
194: FROM hr_organization_information
195: WHERE organization_id = p_org_id
196: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
197:
198: BEGIN

Line 551: FROM hr_organization_information hoi

547:
548: CURSOR csr_le_holidaypay(csr_organization_id IN NUMBER) IS
549: SELECT hoi.org_information6,
550: hoi.org_information7
551: FROM hr_organization_information hoi
552: WHERE organization_id = csr_organization_id
553: AND org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
554:
555: CURSOR csr_asg_holidaypay IS