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 37: p_start_person_id in per_all_people_f.person_id%type,

33: -----------------------------------------------------------------------+
34:
35: procedure assignment_action_code
36: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
37: p_start_person_id in per_all_people_f.person_id%type,
38: p_end_person_id in per_all_people_f.person_id%type,
39: p_chunk in number) is
40:
41: v_next_action_id pay_assignment_actions.assignment_action_id%type;

Line 38: p_end_person_id in per_all_people_f.person_id%type,

34:
35: procedure assignment_action_code
36: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
37: p_start_person_id in per_all_people_f.person_id%type,
38: p_end_person_id in per_all_people_f.person_id%type,
39: p_chunk in number) is
40:
41: v_next_action_id pay_assignment_actions.assignment_action_id%type;
42: v_run_action_id pay_assignment_actions.assignment_action_id%type;

Line 63: c_start_person_id in per_all_people_f.person_id%type,

59:
60:
61: CURSOR process_assignments_val
62: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
63: c_start_person_id in per_all_people_f.person_id%type,
64: c_end_person_id in per_all_people_f.person_id%type)
65: IS
66: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
67: paa.assignment_action_id ps_report_id,

Line 64: c_end_person_id in per_all_people_f.person_id%type)

60:
61: CURSOR process_assignments_val
62: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
63: c_start_person_id in per_all_people_f.person_id%type,
64: c_end_person_id in per_all_people_f.person_id%type)
65: IS
66: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
67: paa.assignment_action_id ps_report_id,
68: paa.assignment_id

Line 84: c_start_person_id in per_all_people_f.person_id%type,

80:
81: /*Bug2920725 Corrected base tables to support security model*/
82: CURSOR process_assignments
83: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
84: c_start_person_id in per_all_people_f.person_id%type,
85: c_end_person_id in per_all_people_f.person_id%type) is
86: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
87: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
88: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)

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

81: /*Bug2920725 Corrected base tables to support security model*/
82: CURSOR process_assignments
83: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
84: c_start_person_id in per_all_people_f.person_id%type,
85: c_end_person_id in per_all_people_f.person_id%type) is
86: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
87: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
88: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
89: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)

Line 139: c_start_person_id in per_all_people_f.person_id%type,

135:
136:
137: CURSOR process_assignments_val_amend /* bug 6630375 */
138: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
139: c_start_person_id in per_all_people_f.person_id%type,
140: c_end_person_id in per_all_people_f.person_id%type)
141: IS
142: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
143: paa.assignment_action_id ps_report_id,

Line 140: c_end_person_id in per_all_people_f.person_id%type)

136:
137: CURSOR process_assignments_val_amend /* bug 6630375 */
138: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
139: c_start_person_id in per_all_people_f.person_id%type,
140: c_end_person_id in per_all_people_f.person_id%type)
141: IS
142: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
143: paa.assignment_action_id ps_report_id,
144: paa.assignment_id

Line 161: c_start_person_id in per_all_people_f.person_id%type,

157:
158:
159: CURSOR process_assignments_amend /* bug 6630375 */
160: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
161: c_start_person_id in per_all_people_f.person_id%type,
162: c_end_person_id in per_all_people_f.person_id%type) is
163: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
164: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
165: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)

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

158:
159: CURSOR process_assignments_amend /* bug 6630375 */
160: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
161: c_start_person_id in per_all_people_f.person_id%type,
162: c_end_person_id in per_all_people_f.person_id%type) is
163: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
164: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
165: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
166: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)