APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 314: from hr_organization_information hoi

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

Line 346: l_creator_uif_reference hr_organization_information.org_information1%type;

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

Line 347: l_contact_person hr_organization_information.org_information2%type;

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

Line 348: l_contact_number hr_organization_information.org_information3%type;

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

Line 349: l_contact_email_address hr_organization_information.org_information4%type;

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

Line 985: l_employer_uif_ref_no hr_organization_information.org_information6%type;

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

Line 988: l_employer_email_address hr_organization_information.org_information10%type;

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

Line 990: l_employer_paye_number hr_organization_information.org_information3%type;

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

Line 999: from hr_organization_information hoi,

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