DBA Data[Home] [Help]

APPS.PER_EVS_MAG_REPORT dependencies on FND_NUMBER

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

22: ,per_all_assignments_f paf
23: ,per_all_people_f ppf
24: ,hr_organization_information hoi
25:
26: WHERE paa.payroll_action_id = fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3))
27: AND paa.assignment_id = paf.assignment_id
28: AND paf.person_id = ppf.person_id
29: AND paf.primary_flag = 'Y'
30: AND paf.effective_start_date = (SELECT max(paf2.effective_start_date)

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

57: ,per_all_people_f ppf
58: ,hr_organization_information hoi
59: where
60: paa.payroll_action_id =
61: fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3))
62: and paa.assignment_id = paf.assignment_id
63: and paf.person_id = ppf.person_id
64: and paf.effective_start_date =
65: (select max(paf2.effective_start_date)