DBA Data[Home] [Help]

APPS.PAY_MX_PAYROLL_ARCH dependencies on PER_ALL_PEOPLE_F

Line 3250: lv_ee_rfc_id per_all_people_f.per_information2%TYPE;

3246: WHERE organization_id = p_tax_unit_id
3247: AND org_information_context = 'MX_SOC_SEC_DETAILS';
3248:
3249: ln_index NUMBER;
3250: lv_ee_rfc_id per_all_people_f.per_information2%TYPE;
3251: lv_ee_ss_id per_all_people_f.per_information3%TYPE;
3252: ln_business_group_id NUMBER;
3253: ln_legal_employer_id NUMBER;
3254: lv_er_rfc_id hr_organization_information.org_information1%TYPE;

Line 3251: lv_ee_ss_id per_all_people_f.per_information3%TYPE;

3247: AND org_information_context = 'MX_SOC_SEC_DETAILS';
3248:
3249: ln_index NUMBER;
3250: lv_ee_rfc_id per_all_people_f.per_information2%TYPE;
3251: lv_ee_ss_id per_all_people_f.per_information3%TYPE;
3252: ln_business_group_id NUMBER;
3253: ln_legal_employer_id NUMBER;
3254: lv_er_rfc_id hr_organization_information.org_information1%TYPE;
3255: lv_er_ss_id hr_organization_information.org_information1%TYPE;