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_PAYROLL_ACTIONS

Line 10: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

6: g_debug boolean := TRUE; --Bug3132178
7:
8:
9: procedure range_code
10: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
11: p_sql out NOCOPY varchar2) is
12: begin
13: -- hr_utility.trace_on(null, 'magtape');
14: hr_utility.set_location('Start of range_code',1);

Line 19: ' pay_payroll_actions pa ' ||

15: /*Bug2920725 Corrected base tables to support security model*/
16:
17: p_sql := ' select distinct p.person_id' ||
18: ' from per_people_f p,' ||
19: ' pay_payroll_actions pa ' ||
20: ' where pa.payroll_action_id = :payroll_action_id' ||
21: ' and p.business_group_id = pa.business_group_id' ||
22: ' order by p.person_id';
23:

Line 36: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

32: -- Actions.
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:

Line 49: l_archive_payroll_action pay_payroll_actions.payroll_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';
49: l_archive_payroll_action pay_payroll_actions.payroll_action_id%type;
50:
51:
52: CURSOR get_parameters
53: IS

Line 57: FROM pay_payroll_actions ppa

53: IS
54: SELECT pay_core_utils.get_parameter('IS_TESTING',ppa.legislative_parameters),
55: pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters),
56: pay_core_utils.get_parameter('PAYMENT_SUMMARY_TYPE',ppa.legislative_parameters) /* bug 6630375 */
57: FROM pay_payroll_actions ppa
58: WHERE ppa.payroll_Action_id = p_payroll_action_id;
59:
60:
61: CURSOR process_assignments_val

Line 62: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

58: WHERE ppa.payroll_Action_id = p_payroll_action_id;
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',

Line 83: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

79:
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)

Line 88: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)

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) */
92: DISTINCT 'ASSIGNMENT_ACTION_ID=C',

Line 95: FROM pay_payroll_actions mpa,

91: INDEX(a PER_ASSIGNMENTS_F_PK) */
92: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
93: ppac.assignment_action_id ps_report_id,
94: ppac.assignment_id
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,

Line 98: pay_payroll_actions apa,

94: ppac.assignment_id
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

Line 100: pay_payroll_actions ppa,

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
104: AND p.person_id = a.person_id

Line 128: pay_payroll_actions paas

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'
132: AND paa1.payroll_action_id = paas.payroll_action_id

Line 138: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

134: AND pail.locked_action_id = ppac.assignment_action_id);
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',

Line 147: pay_payroll_actions ppa

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
150: AND ppa.action_status = 'C'
151: AND a.assignment_id = paa.assignment_id

Line 160: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

156: AND a.person_id BETWEEN c_start_person_id AND c_end_person_id ;
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)

Line 165: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)

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) */
169: DISTINCT 'ASSIGNMENT_ACTION_ID=C',

Line 172: FROM pay_payroll_actions mpa,

168: INDEX(a PER_ASSIGNMENTS_F_PK) */
169: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
170: ppac.assignment_action_id ps_report_id,
171: ppac.assignment_id
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,

Line 175: pay_payroll_actions apa,

171: ppac.assignment_id
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

Line 177: pay_payroll_actions ppa,

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
181: AND p.person_id = a.person_id

Line 206: pay_payroll_actions paas

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'
210: AND paa1.payroll_action_id = paas.payroll_action_id

Line 338: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

334: -- assume that no archival of data is required.
335: ------------------------------------------------------------------------+
336:
337: procedure initialization_code
338: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
339: begin
340: IF g_debug THEN
341: hr_utility.set_location('Start of initialization_code',6);
342: END IF;