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 PAY_ASSIGNMENT_ACTIONS

Line 41: v_next_action_id pay_assignment_actions.assignment_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;
43: p_assignment_id pay_assignment_Actions.assignment_id%type;
44: ps_report_id pay_assignment_actions.assignment_action_id%type;
45: l_payment_summary_type varchar2(5) := 'O'; /* bug 6630375 */

Line 42: v_run_action_id pay_assignment_actions.assignment_action_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;
43: p_assignment_id pay_assignment_Actions.assignment_id%type;
44: ps_report_id pay_assignment_actions.assignment_action_id%type;
45: l_payment_summary_type varchar2(5) := 'O'; /* bug 6630375 */
46:

Line 43: p_assignment_id pay_assignment_Actions.assignment_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;
43: p_assignment_id pay_assignment_Actions.assignment_id%type;
44: ps_report_id pay_assignment_actions.assignment_action_id%type;
45: l_payment_summary_type varchar2(5) := 'O'; /* bug 6630375 */
46:
47: ------start of Bug3132178-----------------------------------------------------

Line 44: ps_report_id pay_assignment_actions.assignment_action_id%type;

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;
43: p_assignment_id pay_assignment_Actions.assignment_id%type;
44: ps_report_id pay_assignment_actions.assignment_action_id%type;
45: l_payment_summary_type varchar2(5) := 'O'; /* bug 6630375 */
46:
47: ------start of Bug3132178-----------------------------------------------------
48: l_testing_flag varchar2(5):='N';

Line 69: FROM pay_assignment_actions paa,

65: IS
66: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
67: paa.assignment_action_id ps_report_id,
68: paa.assignment_id
69: FROM pay_assignment_actions paa,
70: per_assignments_f a
71: WHERE paa.payroll_action_id = c_payroll_action_id
72: AND paa.action_status = 'C'
73: AND a.assignment_id = paa.assignment_id

Line 86: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)

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)
90: INDEX (p PER_PEOPLE_F_PK)

Line 87: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)

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)
90: INDEX (p PER_PEOPLE_F_PK)
91: INDEX(a PER_ASSIGNMENTS_F_PK) */

Line 99: pay_assignment_actions apac,

95: FROM pay_payroll_actions mpa,
96: per_people_f p,
97: per_assignments_f a,
98: pay_payroll_actions apa,
99: pay_assignment_actions apac,
100: pay_payroll_actions ppa,
101: pay_assignment_actions ppac,
102: pay_action_interlocks ppai
103: WHERE mpa.payroll_action_id =c_payroll_action_id

Line 101: pay_assignment_actions ppac,

97: per_assignments_f a,
98: pay_payroll_actions apa,
99: pay_assignment_actions apac,
100: pay_payroll_actions ppa,
101: pay_assignment_actions ppac,
102: pay_action_interlocks ppai
103: WHERE mpa.payroll_action_id =c_payroll_action_id
104: AND p.person_id = a.person_id
105: AND p.person_id BETWEEN c_start_person_id AND c_end_person_id

Line 127: pay_assignment_actions paa1,

123: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
124: AND NOT EXISTS /* 5471093 */
125: (SELECT /*+ ORDERED */ locked_action_id
126: FROM pay_action_interlocks pail,
127: pay_assignment_actions paa1,
128: pay_payroll_actions paas
129: WHERE paas.action_type='X'
130: and paas.action_status='C'
131: AND paas.report_type='AU_PS_DATA_FILE'

Line 145: FROM pay_assignment_actions paa,

141: IS
142: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
143: paa.assignment_action_id ps_report_id,
144: paa.assignment_id
145: FROM pay_assignment_actions paa,
146: per_assignments_f a,
147: pay_payroll_actions ppa
148: WHERE ppa.payroll_action_id = c_payroll_action_id
149: AND ppa.payroll_action_id = paa.payroll_action_id

Line 163: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)

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)
167: INDEX (p PER_PEOPLE_F_PK)

Line 164: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)

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)
167: INDEX (p PER_PEOPLE_F_PK)
168: INDEX(a PER_ASSIGNMENTS_F_PK) */

Line 176: pay_assignment_actions apac,

172: FROM pay_payroll_actions mpa,
173: per_people_f p,
174: per_assignments_f a,
175: pay_payroll_actions apa,
176: pay_assignment_actions apac,
177: pay_payroll_actions ppa,
178: pay_assignment_actions ppac,
179: pay_action_interlocks ppai
180: WHERE mpa.payroll_action_id =c_payroll_action_id

Line 178: pay_assignment_actions ppac,

174: per_assignments_f a,
175: pay_payroll_actions apa,
176: pay_assignment_actions apac,
177: pay_payroll_actions ppa,
178: pay_assignment_actions ppac,
179: pay_action_interlocks ppai
180: WHERE mpa.payroll_action_id =c_payroll_action_id
181: AND p.person_id = a.person_id
182: AND p.person_id BETWEEN c_start_person_id AND c_end_person_id

Line 205: pay_assignment_actions paa1,

201: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
202: AND NOT EXISTS /* 5471093 */
203: (SELECT /*+ ORDERED */ locked_action_id
204: FROM pay_action_interlocks pail,
205: pay_assignment_actions paa1,
206: pay_payroll_actions paas
207: WHERE paas.action_type='X'
208: and paas.action_status='C'
209: AND paas.report_type='AU_PS_DATA_FILE'

Line 215: SELECT pay_assignment_actions_s.NEXTVAL

211: AND pail.locking_action_id = paa1.assignment_action_id
212: AND pail.locked_action_id = ppac.assignment_action_id);
213:
214: CURSOR next_action_id IS
215: SELECT pay_assignment_actions_s.NEXTVAL
216: FROM dual;
217:
218: BEGIN
219:

Line 355: (p_payroll_action_id in pay_assignment_actions.payroll_action_id%type,

351: -- Used to actually perform the archival of data. We are not archiving
352: -- any data here, so this is null.
353: ------------------------------------------------------------------------+
354: procedure archive_code
355: (p_payroll_action_id in pay_assignment_actions.payroll_action_id%type,
356: p_effective_date in date)
357: is
358:
359: begin