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.

APPS.PAY_MX_YREND_ARCH dependencies on PER_PEOPLE_F

Line 1144: per_people_f ppf

1140: ppf.full_name "Legal Representative Name",
1141: ppf.per_information2 "Legal Representative RFC",
1142: ppf.national_identifier "Legal Representative CURP"
1143: FROM hr_organization_information hoi,
1144: per_people_f ppf
1145: WHERE hoi.organization_id = cp_legal_er_id
1146: AND hoi.org_information_context = 'MX_TAX_REGISTRATION'
1147: AND hoi.org_information3 = ppf.person_id
1148: AND cp_effective_date BETWEEN ppf.effective_start_date

Line 1232: lv_paternal_last_name per_people_f.last_name%TYPE;

1228: ln_person_id NUMBER;
1229: ln_assignment_id NUMBER;
1230: ln_tax_unit_id NUMBER;
1231: ln_chunk_number NUMBER;
1232: lv_paternal_last_name per_people_f.last_name%TYPE;
1233: lv_maternal_last_name per_people_f.per_information1%TYPE;
1234: lv_names per_people_f.full_name%TYPE;
1235: lv_CURP per_people_f.national_identifier%TYPE;
1236: lv_RFC_ID per_people_f.per_information2%TYPE;

Line 1233: lv_maternal_last_name per_people_f.per_information1%TYPE;

1229: ln_assignment_id NUMBER;
1230: ln_tax_unit_id NUMBER;
1231: ln_chunk_number NUMBER;
1232: lv_paternal_last_name per_people_f.last_name%TYPE;
1233: lv_maternal_last_name per_people_f.per_information1%TYPE;
1234: lv_names per_people_f.full_name%TYPE;
1235: lv_CURP per_people_f.national_identifier%TYPE;
1236: lv_RFC_ID per_people_f.per_information2%TYPE;
1237: ld_arch_start_date DATE;

Line 1234: lv_names per_people_f.full_name%TYPE;

1230: ln_tax_unit_id NUMBER;
1231: ln_chunk_number NUMBER;
1232: lv_paternal_last_name per_people_f.last_name%TYPE;
1233: lv_maternal_last_name per_people_f.per_information1%TYPE;
1234: lv_names per_people_f.full_name%TYPE;
1235: lv_CURP per_people_f.national_identifier%TYPE;
1236: lv_RFC_ID per_people_f.per_information2%TYPE;
1237: ld_arch_start_date DATE;
1238: ld_arch_end_date DATE;

Line 1235: lv_CURP per_people_f.national_identifier%TYPE;

1231: ln_chunk_number NUMBER;
1232: lv_paternal_last_name per_people_f.last_name%TYPE;
1233: lv_maternal_last_name per_people_f.per_information1%TYPE;
1234: lv_names per_people_f.full_name%TYPE;
1235: lv_CURP per_people_f.national_identifier%TYPE;
1236: lv_RFC_ID per_people_f.per_information2%TYPE;
1237: ld_arch_start_date DATE;
1238: ld_arch_end_date DATE;
1239: ln_seniority NUMBER;

Line 1236: lv_RFC_ID per_people_f.per_information2%TYPE;

1232: lv_paternal_last_name per_people_f.last_name%TYPE;
1233: lv_maternal_last_name per_people_f.per_information1%TYPE;
1234: lv_names per_people_f.full_name%TYPE;
1235: lv_CURP per_people_f.national_identifier%TYPE;
1236: lv_RFC_ID per_people_f.per_information2%TYPE;
1237: ld_arch_start_date DATE;
1238: ld_arch_end_date DATE;
1239: ln_seniority NUMBER;
1240: ln_tax_subsidy_prop NUMBER;

Line 1327: FROM per_people_f ppf,

1323: ppf.business_group_id,
1324: paa.tax_unit_id,
1325: cp_effective_date), 4),
1326: hl.region_1 "Jurisdiction"
1327: FROM per_people_f ppf,
1328: per_assignments_f paf,
1329: per_assignments_f paf_all,
1330: pay_assignment_actions paa,
1331: per_periods_of_service pps,

Line 1417: FROM per_people_f ppf,

1413: nvl(paf.effective_end_date, p_effective_date)),
1414: NVL(pps.actual_termination_date,
1415: fnd_date.canonical_to_date(g_fiscal_year || '/12/31')
1416: )
1417: FROM per_people_f ppf,
1418: per_assignments_f paf,
1419: pay_assignment_actions paa,
1420: pay_payroll_actions ppa,
1421: per_periods_of_service pps