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 128: FROM hr_organization_information

124: IS
125: l_sector varchar2(1);
126: CURSOR GET_AE_SECTOR (l_tax_unit_id number) IS
127: SELECT org_information6
128: FROM hr_organization_information
129: WHERE organization_id = l_tax_unit_id
130: AND org_information_context = 'AE_LEGAL_EMPLOYER_DETAILS';
131: begin
132: l_sector := null;

Line 592: ,hr_organization_information HOI1

588: RETURN VARCHAR2 IS
589: cursor csr_get_formula_id is
590: select HOI2.org_information1
591: from hr_organization_units HOU
592: ,hr_organization_information HOI1
593: ,hr_organization_information HOI2
594: ,hr_soft_coding_keyflex HSCK
595: ,per_all_assignments_f PAA
596: where HOU.business_group_id = PAA.business_group_id

Line 593: ,hr_organization_information HOI2

589: cursor csr_get_formula_id is
590: select HOI2.org_information1
591: from hr_organization_units HOU
592: ,hr_organization_information HOI1
593: ,hr_organization_information HOI2
594: ,hr_soft_coding_keyflex HSCK
595: ,per_all_assignments_f PAA
596: where HOU.business_group_id = PAA.business_group_id
597: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,

Line 698: ,hr_organization_information HOI1

694: return NUMBER is
695: cursor csr_get_formula_id is
696: select HOI2.org_information2
697: from hr_organization_units HOU
698: ,hr_organization_information HOI1
699: ,hr_organization_information HOI2
700: ,hr_soft_coding_keyflex HSCK
701: ,per_all_assignments_f PAA
702: where HOU.business_group_id = PAA.business_group_id

Line 699: ,hr_organization_information HOI2

695: cursor csr_get_formula_id is
696: select HOI2.org_information2
697: from hr_organization_units HOU
698: ,hr_organization_information HOI1
699: ,hr_organization_information HOI2
700: ,hr_soft_coding_keyflex HSCK
701: ,per_all_assignments_f PAA
702: where HOU.business_group_id = PAA.business_group_id
703: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,

Line 784: ,hr_organization_information HOI1

780: return NUMBER is
781: cursor csr_get_formula_id is
782: select HOI2.org_information3
783: from hr_organization_units HOU
784: ,hr_organization_information HOI1
785: ,hr_organization_information HOI2
786: ,hr_soft_coding_keyflex HSCK
787: ,per_all_assignments_f PAA
788: where HOU.business_group_id = PAA.business_group_id

Line 785: ,hr_organization_information HOI2

781: cursor csr_get_formula_id is
782: select HOI2.org_information3
783: from hr_organization_units HOU
784: ,hr_organization_information HOI1
785: ,hr_organization_information HOI2
786: ,hr_soft_coding_keyflex HSCK
787: ,per_all_assignments_f PAA
788: where HOU.business_group_id = PAA.business_group_id
789: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,

Line 904: ,hr_organization_information HOI1

900: RETURN VARCHAR2 IS
901: CURSOR csr_get_gratuity_basis IS
902: select NVL(HOI2.org_information1,'X')
903: from hr_organization_units HOU
904: ,hr_organization_information HOI1
905: ,hr_organization_information HOI2
906: ,hr_soft_coding_keyflex HSCK
907: ,per_all_assignments_f PAA
908: where HOU.business_group_id = PAA.business_group_id

Line 905: ,hr_organization_information HOI2

901: CURSOR csr_get_gratuity_basis IS
902: select NVL(HOI2.org_information1,'X')
903: from hr_organization_units HOU
904: ,hr_organization_information HOI1
905: ,hr_organization_information HOI2
906: ,hr_soft_coding_keyflex HSCK
907: ,per_all_assignments_f PAA
908: where HOU.business_group_id = PAA.business_group_id
909: and trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,