DBA Data[Home] [Help]

APPS.PER_EVS_MAG_REPORT dependencies on FND_NUMBER

Line 35: WHERE paa.payroll_action_id = fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3))

31: ,per_all_assignments_f paf
32: ,per_all_people_f ppf
33: ,hr_organization_information hoi
34:
35: WHERE paa.payroll_action_id = fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3))
36: AND paa.assignment_id = paf.assignment_id
37: AND paf.person_id = ppf.person_id
38: AND paf.primary_flag = 'Y'
39: AND paf.effective_start_date = (SELECT max(paf2.effective_start_date)

Line 70: fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3))

66: ,per_all_people_f ppf
67: ,hr_organization_information hoi
68: where
69: paa.payroll_action_id =
70: fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3))
71: and paa.assignment_id = paf.assignment_id
72: and paf.person_id = ppf.person_id
73: and paf.effective_start_date =
74: (select max(paf2.effective_start_date)