APPS.PAY_DK_HOLIDAY_PAY_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 39: FROM hr_organization_information

35: ) RETURN NUMBER is
36:
37: CURSOR csr_get_hol_rates(p_org_id NUMBER) is
38: SELECT org_information10, fnd_number.canonical_to_number(org_information12),fnd_number.canonical_to_number(org_information13)
39: FROM hr_organization_information
40: WHERE organization_id = p_org_id
41: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
42:
43: BEGIN

Line 113: FROM hr_organization_information

109: /* Bug fix 4950983 added org_information1 in select clause */
110: /* Change the to_number to fnd_number.canonical_to_number */
111: CURSOR csr_get_hol_rates(p_org_id NUMBER) is
112: SELECT fnd_number.canonical_to_number(org_information4), fnd_number.canonical_to_number(org_information3), org_information5, org_information1, org_information8 --9559824 abraghun - swapped first two columns.
113: FROM hr_organization_information
114: WHERE organization_id = p_org_id
115: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
116:
117: BEGIN

Line 139: FROM hr_organization_information hoi

135: --
136: CURSOR get_details(p_org_id VARCHAR2) IS
137: SELECT hoi.org_information3
138: , hoi.org_information4
139: FROM hr_organization_information hoi
140: WHERE hoi.org_information_context='DK_EMPLOYMENT_DEFAULTS'
141: AND hoi.organization_id = p_org_id ;
142:
143: --

Line 234: FROM hr_organization_information

230:
231:
232: CURSOR csr_get_le_work_pattern(p_org_id NUMBER) IS
233: SELECT org_information1
234: FROM hr_organization_information
235: WHERE organization_id = p_org_id
236: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
237:
238: BEGIN

Line 591: FROM hr_organization_information hoi

587:
588: CURSOR csr_le_holidaypay(csr_organization_id IN NUMBER) IS
589: SELECT hoi.org_information6,
590: hoi.org_information7
591: FROM hr_organization_information hoi
592: WHERE organization_id = csr_organization_id
593: AND org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
594:
595: CURSOR csr_asg_holidaypay IS

Line 652: hr_organization_information

648: CURSOR csr_organization_carryover(c_organization_id number) IS
649: SELECT
650: org_information9 org_max_carryover
651: FROM
652: hr_organization_information
653: WHERE organization_id = c_organization_id
654: AND org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
655:
656: ----Global Setting----