DBA Data[Home] [Help]

APPS.PAY_MX_PAYROLL_ARCH dependencies on PER_PEOPLE_F

Line 3096: FROM per_people_f ppf

3092: || DECODE(per_information1, NULL,'',' ' || per_information1)
3093: || DECODE(first_name,NULL, '', ' ' || first_name)
3094: || DECODE(middle_names,NULL, '', ' ' || middle_names)
3095: ))
3096: FROM per_people_f ppf
3097: WHERE ppf.person_id =
3098: (SELECT person_id FROM per_assignments_f paf
3099: WHERE assignment_id = cp_assignment_id
3100: AND cp_effective_date BETWEEN paf.effective_start_date

Line 3225: per_people_f ppf

3221: ) IS
3222: SELECT ppf.per_information2 rfc_id,
3223: ppf.per_information3 ss_id
3224: FROM per_assignments_f paf,
3225: per_people_f ppf
3226: WHERE paf.person_id = ppf.person_id
3227: AND paf.assignment_id = cp_assignment_id
3228: AND cp_curr_eff_date BETWEEN paf.effective_start_date
3229: AND paf.effective_end_date