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_AU_PAYMENT_SUMMARY_MAGTAPE dependencies on PER_ALL_PEOPLE_F

Line 103: p_start_person_id in per_all_people_f.person_id%type,

99: -----------------------------------------------------------------------+
100:
101: procedure assignment_action_code
102: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
103: p_start_person_id in per_all_people_f.person_id%type,
104: p_end_person_id in per_all_people_f.person_id%type,
105: p_chunk in number) is
106:
107: v_next_action_id pay_assignment_actions.assignment_action_id%type;

Line 104: p_end_person_id in per_all_people_f.person_id%type,

100:
101: procedure assignment_action_code
102: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
103: p_start_person_id in per_all_people_f.person_id%type,
104: p_end_person_id in per_all_people_f.person_id%type,
105: p_chunk in number) is
106:
107: v_next_action_id pay_assignment_actions.assignment_action_id%type;
108: v_run_action_id pay_assignment_actions.assignment_action_id%type;

Line 129: c_start_person_id in per_all_people_f.person_id%type,

125:
126:
127: CURSOR process_assignments_val
128: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
129: c_start_person_id in per_all_people_f.person_id%type,
130: c_end_person_id in per_all_people_f.person_id%type)
131: IS
132: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
133: paa.assignment_action_id ps_report_id,

Line 130: c_end_person_id in per_all_people_f.person_id%type)

126:
127: CURSOR process_assignments_val
128: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
129: c_start_person_id in per_all_people_f.person_id%type,
130: c_end_person_id in per_all_people_f.person_id%type)
131: IS
132: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
133: paa.assignment_action_id ps_report_id,
134: paa.assignment_id

Line 171: c_start_person_id in per_all_people_f.person_id%type,

167:
168: /*Bug2920725 Corrected base tables to support security model*/
169: CURSOR process_assignments
170: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
171: c_start_person_id in per_all_people_f.person_id%type,
172: c_end_person_id in per_all_people_f.person_id%type) is
173: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
174: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
175: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)

Line 172: c_end_person_id in per_all_people_f.person_id%type) is

168: /*Bug2920725 Corrected base tables to support security model*/
169: CURSOR process_assignments
170: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
171: c_start_person_id in per_all_people_f.person_id%type,
172: c_end_person_id in per_all_people_f.person_id%type) is
173: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
174: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
175: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
176: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)

Line 301: c_start_person_id in per_all_people_f.person_id%type,

297:
298:
299: CURSOR process_assignments_val_amend /* bug 6630375 */
300: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
301: c_start_person_id in per_all_people_f.person_id%type,
302: c_end_person_id in per_all_people_f.person_id%type)
303: IS
304: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
305: paa.assignment_action_id ps_report_id,

Line 302: c_end_person_id in per_all_people_f.person_id%type)

298:
299: CURSOR process_assignments_val_amend /* bug 6630375 */
300: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
301: c_start_person_id in per_all_people_f.person_id%type,
302: c_end_person_id in per_all_people_f.person_id%type)
303: IS
304: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
305: paa.assignment_action_id ps_report_id,
306: paa.assignment_id

Line 345: c_start_person_id in per_all_people_f.person_id%type,

341:
342:
343: CURSOR process_assignments_amend /* bug 6630375 */
344: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
345: c_start_person_id in per_all_people_f.person_id%type,
346: c_end_person_id in per_all_people_f.person_id%type) is
347: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
348: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
349: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)

Line 346: c_end_person_id in per_all_people_f.person_id%type) is

342:
343: CURSOR process_assignments_amend /* bug 6630375 */
344: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
345: c_start_person_id in per_all_people_f.person_id%type,
346: c_end_person_id in per_all_people_f.person_id%type) is
347: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
348: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
349: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
350: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)