eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_MX_YREND_ARCH dependencies on PER_PEOPLE_F

Line 1364: per_people_f ppf

1360: ppf.full_name "Legal Representative Name",
1361: ppf.per_information2 "Legal Representative RFC",
1362: ppf.national_identifier "Legal Representative CURP"
1363: FROM hr_organization_information hoi,
1364: per_people_f ppf
1365: WHERE hoi.organization_id = cp_legal_er_id
1366: AND hoi.org_information_context = 'MX_TAX_REGISTRATION'
1367: AND hoi.org_information3 = ppf.person_id
1368: AND cp_effective_date BETWEEN ppf.effective_start_date

Line 1457: lv_paternal_last_name per_people_f.last_name%TYPE;

1453: ln_person_id NUMBER;
1454: ln_assignment_id NUMBER;
1455: ln_tax_unit_id NUMBER;
1456: ln_chunk_number NUMBER;
1457: lv_paternal_last_name per_people_f.last_name%TYPE;
1458: lv_maternal_last_name per_people_f.per_information1%TYPE;
1459: lv_names per_people_f.full_name%TYPE;
1460: lv_CURP per_people_f.national_identifier%TYPE;
1461: lv_RFC_ID per_people_f.per_information2%TYPE;

Line 1458: lv_maternal_last_name per_people_f.per_information1%TYPE;

1454: ln_assignment_id NUMBER;
1455: ln_tax_unit_id NUMBER;
1456: ln_chunk_number NUMBER;
1457: lv_paternal_last_name per_people_f.last_name%TYPE;
1458: lv_maternal_last_name per_people_f.per_information1%TYPE;
1459: lv_names per_people_f.full_name%TYPE;
1460: lv_CURP per_people_f.national_identifier%TYPE;
1461: lv_RFC_ID per_people_f.per_information2%TYPE;
1462: ld_arch_start_date DATE;

Line 1459: lv_names per_people_f.full_name%TYPE;

1455: ln_tax_unit_id NUMBER;
1456: ln_chunk_number NUMBER;
1457: lv_paternal_last_name per_people_f.last_name%TYPE;
1458: lv_maternal_last_name per_people_f.per_information1%TYPE;
1459: lv_names per_people_f.full_name%TYPE;
1460: lv_CURP per_people_f.national_identifier%TYPE;
1461: lv_RFC_ID per_people_f.per_information2%TYPE;
1462: ld_arch_start_date DATE;
1463: ld_arch_end_date DATE;

Line 1460: lv_CURP per_people_f.national_identifier%TYPE;

1456: ln_chunk_number NUMBER;
1457: lv_paternal_last_name per_people_f.last_name%TYPE;
1458: lv_maternal_last_name per_people_f.per_information1%TYPE;
1459: lv_names per_people_f.full_name%TYPE;
1460: lv_CURP per_people_f.national_identifier%TYPE;
1461: lv_RFC_ID per_people_f.per_information2%TYPE;
1462: ld_arch_start_date DATE;
1463: ld_arch_end_date DATE;
1464: ln_seniority NUMBER;

Line 1461: lv_RFC_ID per_people_f.per_information2%TYPE;

1457: lv_paternal_last_name per_people_f.last_name%TYPE;
1458: lv_maternal_last_name per_people_f.per_information1%TYPE;
1459: lv_names per_people_f.full_name%TYPE;
1460: lv_CURP per_people_f.national_identifier%TYPE;
1461: lv_RFC_ID per_people_f.per_information2%TYPE;
1462: ld_arch_start_date DATE;
1463: ld_arch_end_date DATE;
1464: ln_seniority NUMBER;
1465: ln_tax_subsidy_prop NUMBER;

Line 1565: FROM per_people_f ppf,

1561: ppf.business_group_id,
1562: paa.tax_unit_id,
1563: cp_effective_date), 4),
1564: hl.region_1 "Jurisdiction"
1565: FROM per_people_f ppf,
1566: per_assignments_f paf,
1567: per_assignments_f paf_all,
1568: pay_assignment_actions paa,
1569: per_periods_of_service pps,

Line 1660: FROM per_people_f ppf,

1656: nvl(paf.effective_end_date, p_effective_date)) effective_date,
1657: NVL(pps.actual_termination_date,
1658: fnd_date.canonical_to_date(g_fiscal_year || '/12/31')
1659: )
1660: FROM per_people_f ppf,
1661: per_assignments_f paf,
1662: pay_assignment_actions paa,
1663: pay_payroll_actions ppa,
1664: per_periods_of_service pps