APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 315: from hr_organization_information hoi

311: select hoi.org_information1,
312: hoi.org_information2,
313: hoi.org_information3,
314: hoi.org_information4
315: from hr_organization_information hoi
316: , hr_all_organization_units org
317: where hoi.org_information_context = 'ZA_UIF_CREATOR_INFO'
318: and hoi.organization_id = org.organization_id
319: and org.organization_id = g_business_group_id;

Line 347: l_creator_uif_reference hr_organization_information.org_information1%type;

343: l_bg_id number;
344: l_canonical_end_date date;
345: l_canonical_start_date date;
346:
347: l_creator_uif_reference hr_organization_information.org_information1%type;
348: l_contact_person hr_organization_information.org_information2%type;
349: l_contact_number hr_organization_information.org_information3%type;
350: l_contact_email_address hr_organization_information.org_information4%type;
351:

Line 348: l_contact_person hr_organization_information.org_information2%type;

344: l_canonical_end_date date;
345: l_canonical_start_date date;
346:
347: l_creator_uif_reference hr_organization_information.org_information1%type;
348: l_contact_person hr_organization_information.org_information2%type;
349: l_contact_number hr_organization_information.org_information3%type;
350: l_contact_email_address hr_organization_information.org_information4%type;
351:
352: l_action_info_id number;

Line 349: l_contact_number hr_organization_information.org_information3%type;

345: l_canonical_start_date date;
346:
347: l_creator_uif_reference hr_organization_information.org_information1%type;
348: l_contact_person hr_organization_information.org_information2%type;
349: l_contact_number hr_organization_information.org_information3%type;
350: l_contact_email_address hr_organization_information.org_information4%type;
351:
352: l_action_info_id number;
353: l_ovn number;

Line 350: l_contact_email_address hr_organization_information.org_information4%type;

346:
347: l_creator_uif_reference hr_organization_information.org_information1%type;
348: l_contact_person hr_organization_information.org_information2%type;
349: l_contact_number hr_organization_information.org_information3%type;
350: l_contact_email_address hr_organization_information.org_information4%type;
351:
352: l_action_info_id number;
353: l_ovn number;
354:

Line 986: l_employer_uif_ref_no hr_organization_information.org_information6%type;

982: and paei.aei_information_category = 'ZA_SPECIFIC_INFO';
983:
984:
985: --Legal Entity Organization Data:
986: l_employer_uif_ref_no hr_organization_information.org_information6%type;
987:
988: /* Changes as per Bug2654703 */
989: l_employer_email_address hr_organization_information.org_information10%type;
990:

Line 989: l_employer_email_address hr_organization_information.org_information10%type;

985: --Legal Entity Organization Data:
986: l_employer_uif_ref_no hr_organization_information.org_information6%type;
987:
988: /* Changes as per Bug2654703 */
989: l_employer_email_address hr_organization_information.org_information10%type;
990:
991: l_employer_paye_number hr_organization_information.org_information3%type;
992:
993: -- call with l_legal_entity from Assignment UIF Data cursor

Line 991: l_employer_paye_number hr_organization_information.org_information3%type;

987:
988: /* Changes as per Bug2654703 */
989: l_employer_email_address hr_organization_information.org_information10%type;
990:
991: l_employer_paye_number hr_organization_information.org_information3%type;
992:
993: -- call with l_legal_entity from Assignment UIF Data cursor
994: cursor csr_leg_entity_data (p_org_id number) is
995: select hoi.org_information17 Employer_UIF_Ref_No, /* changes as per bug 9815318 */

Line 1001: from hr_organization_information hoi,

997: /* Changes as per Bug2654703 */
998: hoi.org_information10 Employer_email_Address,
999:
1000: hoi.org_information3 Employer_PAYE_Number
1001: from hr_organization_information hoi,
1002: hr_all_organization_units org
1003: where org.organization_id = p_org_id
1004: and org.organization_id = hoi.organization_id
1005: and hoi.org_information_context = 'ZA_LEGAL_ENTITY';