APPS.PAY_AE_GENERAL dependencies on HR_ORGANIZATION_INFORMATION

Line 20: From HR_ORGANIZATION_INFORMATION

16: BEGIN
17: l_organization_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
18: Select Org_Information1
19: Into l_nationality_cd
20: From HR_ORGANIZATION_INFORMATION
21: Where ORG_INFORMATION_CONTEXT = 'AE_BG_DETAILS'
22: And ORGANIZATION_ID = l_organization_id;
23: EXCEPTION
24: WHEN no_data_found Then

Line 90: FROM hr_organization_information

86: IS
87: l_sector varchar2(1);
88: CURSOR GET_AE_SECTOR (l_tax_unit_id number) IS
89: SELECT org_information6
90: FROM hr_organization_information
91: WHERE organization_id = l_tax_unit_id
92: AND org_information_context = 'AE_LEGAL_EMPLOYER_DETAILS';
93: begin
94: l_sector := null;

Line 526: ,hr_organization_information HOI1

522: RETURN VARCHAR2 IS
523: cursor csr_get_formula_id is
524: select HOI2.org_information1
525: from hr_organization_units HOU
526: ,hr_organization_information HOI1
527: ,hr_organization_information HOI2
528: ,hr_soft_coding_keyflex HSCK
529: ,per_all_assignments_f PAA
530: where HOU.business_group_id = PAA.business_group_id

Line 527: ,hr_organization_information HOI2

523: cursor csr_get_formula_id is
524: select HOI2.org_information1
525: from hr_organization_units HOU
526: ,hr_organization_information HOI1
527: ,hr_organization_information HOI2
528: ,hr_soft_coding_keyflex HSCK
529: ,per_all_assignments_f PAA
530: where HOU.business_group_id = PAA.business_group_id
531: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,

Line 632: ,hr_organization_information HOI1

628: return NUMBER is
629: cursor csr_get_formula_id is
630: select HOI2.org_information2
631: from hr_organization_units HOU
632: ,hr_organization_information HOI1
633: ,hr_organization_information HOI2
634: ,hr_soft_coding_keyflex HSCK
635: ,per_all_assignments_f PAA
636: where HOU.business_group_id = PAA.business_group_id

Line 633: ,hr_organization_information HOI2

629: cursor csr_get_formula_id is
630: select HOI2.org_information2
631: from hr_organization_units HOU
632: ,hr_organization_information HOI1
633: ,hr_organization_information HOI2
634: ,hr_soft_coding_keyflex HSCK
635: ,per_all_assignments_f PAA
636: where HOU.business_group_id = PAA.business_group_id
637: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,

Line 718: ,hr_organization_information HOI1

714: return NUMBER is
715: cursor csr_get_formula_id is
716: select HOI2.org_information3
717: from hr_organization_units HOU
718: ,hr_organization_information HOI1
719: ,hr_organization_information HOI2
720: ,hr_soft_coding_keyflex HSCK
721: ,per_all_assignments_f PAA
722: where HOU.business_group_id = PAA.business_group_id

Line 719: ,hr_organization_information HOI2

715: cursor csr_get_formula_id is
716: select HOI2.org_information3
717: from hr_organization_units HOU
718: ,hr_organization_information HOI1
719: ,hr_organization_information HOI2
720: ,hr_soft_coding_keyflex HSCK
721: ,per_all_assignments_f PAA
722: where HOU.business_group_id = PAA.business_group_id
723: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,

Line 838: ,hr_organization_information HOI1

834: RETURN VARCHAR2 IS
835: CURSOR csr_get_gratuity_basis IS
836: select NVL(HOI2.org_information1,'X')
837: from hr_organization_units HOU
838: ,hr_organization_information HOI1
839: ,hr_organization_information HOI2
840: ,hr_soft_coding_keyflex HSCK
841: ,per_all_assignments_f PAA
842: where HOU.business_group_id = PAA.business_group_id

Line 839: ,hr_organization_information HOI2

835: CURSOR csr_get_gratuity_basis IS
836: select NVL(HOI2.org_information1,'X')
837: from hr_organization_units HOU
838: ,hr_organization_information HOI1
839: ,hr_organization_information HOI2
840: ,hr_soft_coding_keyflex HSCK
841: ,per_all_assignments_f PAA
842: where HOU.business_group_id = PAA.business_group_id
843: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,