DBA Data[Home] [Help]

APPS.PAY_HK_IR56_MAGTAPE dependencies on PER_ASSIGNMENTS_F

Line 30: ** by secured views per_assignments_f and per_people_f in ir56b_details

26: ** report
27: ** 23 JAN 2003 CTREDWIN - Syntax correction
28: ** 19 APR 2003 NANURADH 2913879 Truncated the value of archived item.
29: ** 29 MAY 2003 KAVERMA 2920731 Replaced tables per_all_assignments_f and per_all_people_f
30: ** by secured views per_assignments_f and per_people_f in ir56b_details
31: */
32:
33:
34: LEVEL_CNT Number;

Line 122: from per_assignments_f paa,

118: 'ASSIGNMENT_ACTION_ID=C',
119: pac3.assignment_action_id,
120: pap.last_name lname, /*Changed to get proper sorted order for bug 2690005*/
121: pap.first_name||' '||pap.middle_names fname
122: from per_assignments_f paa,
123: pay_payroll_actions ppa, -- Magtape payroll action
124: pay_payroll_actions ppa2, -- Report payroll action
125: pay_payroll_actions ppa3, -- Archive payroll action
126: pay_assignment_actions pac,