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_SOE_GLB dependencies on PAY_PAYROLL_ACTIONS

Line 29: from pay_payroll_actions pa

25: , aa.tax_unit_id
26: ,'''' || bg.currency_code || '''' currency_code
27: ,action_type
28: ,fc.name currency_name
29: from pay_payroll_actions pa
30: , pay_assignment_actions aa
31: , per_business_groups bg
32: , fnd_currencies_vl fc
33: where aa.assignment_action_id = p_assignment_action_id

Line 50: l_action_type pay_payroll_actions.action_type%type;

46: start with assignment_action_id = p_assignment_action_id)
47: connect by source_action_id = prior assignment_action_id
48: start with assignment_action_id = p_assignment_action_id;
49:
50: l_action_type pay_payroll_actions.action_type%type;
51:
52: cursor lockedActions is
53: select locked_action_id,
54: action_sequence

Line 78: from pay_payroll_actions pa

74: --
75: -- Prepay change
76: select action_type
77: into l_action_type
78: from pay_payroll_actions pa
79: ,pay_assignment_actions aa
80: where aa.assignment_action_id = p_assignment_action_id
81: and aa.payroll_action_id = pa.payroll_action_id;
82:

Line 174: from pay_payroll_actions pa,

170: * Removed join with per_time_periods to fetch the latest assignment action
171: * id of the assignment irrespective of the session date.*/
172: cursor csr_get_action_id (asg_id number) is
173: select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
174: from pay_payroll_actions pa,
175: pay_assignment_actions aa
176: -- per_time_periods ptp
177: where aa.action_status = 'C'
178: and pa.payroll_action_id = aa.payroll_action_id

Line 313: pay_payroll_actions pa

309: --
310: l_action_type varchar2(2);
311: cursor periodDates is
312: select pa.action_type from
313: pay_payroll_actions pa
314: , pay_assignment_actions aa
315: where pa.payroll_action_id = aa.payroll_action_id
316: and aa.assignment_action_id = p_assignment_action_id;
317:

Line 341: ,pay_payroll_actions pa1

337: ,fnd_date.date_to_displaydate(tp1.start_date,2) COL02 -- change as per bug 11830805
338: ,tp1.period_type COL07
339: from pay_all_payrolls_f pp1
340: ,pay_all_payrolls_f pp2
341: ,pay_payroll_actions pa1
342: ,pay_payroll_actions pa2
343: ,per_time_periods tp1
344: ,per_time_periods tp2
345: ,pay_assignment_actions aa1

Line 342: ,pay_payroll_actions pa2

338: ,tp1.period_type COL07
339: from pay_all_payrolls_f pp1
340: ,pay_all_payrolls_f pp2
341: ,pay_payroll_actions pa1
342: ,pay_payroll_actions pa2
343: ,per_time_periods tp1
344: ,per_time_periods tp2
345: ,pay_assignment_actions aa1
346: ,pay_assignment_actions aa2

Line 382: from pay_payroll_actions pa

378: ,fnd_date.date_to_displaydate(aa.start_date,2) COL05 -- change as per bug 11830805
379: ,fnd_date.date_to_displaydate(aa.end_date,2) COL06 -- change as per bug 11830805
380: ,fnd_date.date_to_displaydate(tp.start_date,2) COL02 -- change as per bug 11830805
381: ,tp.period_type COL07
382: from pay_payroll_actions pa
383: ,per_time_periods tp
384: ,pay_assignment_actions aa
385: where pa.payroll_action_id = aa.payroll_action_id
386: -- Bug 9877851 : Included join on time period id rather than on effective date

Line 401: from pay_payroll_actions pa

397: ,fnd_date.date_to_displaydate(aa.start_date,2) COL05 -- change as per bug 11830805
398: ,fnd_date.date_to_displaydate(aa.end_date,2) COL06 -- change as per bug 11830805
399: ,fnd_date.date_to_displaydate(tp.start_date,2) COL02 -- change as per bug 11830805
400: ,tp.period_type COL07
401: from pay_payroll_actions pa
402: ,per_time_periods tp
403: ,pay_assignment_actions aa
404: where pa.payroll_action_id = aa.payroll_action_id
405: and pa.time_period_id = tp.time_period_id

Line 598: from pay_payroll_actions pa

594: , aa.assignment_id
595: , pa.business_group_id
596: , bg.legislation_code
597: , lrl.rule_mode
598: from pay_payroll_actions pa
599: , pay_assignment_actions aa
600: , per_business_groups bg
601: , pay_legislation_rules lrl
602: where aa.assignment_action_id = p_assignment_action_id

Line 649: , pay_payroll_actions pa

645: , rb.SOURCE_NUMBER
646: , rb.SOURCE_TEXT2
647: from pay_run_balances rb
648: , pay_assignment_actions aa
649: , pay_payroll_actions pa
650: where rb.ASSIGNMENT_ID = l_assignment_id
651: and l_action_sequence >= aa.action_sequence
652: and rb.assignment_action_id = aa.assignment_action_id
653: and aa.payroll_action_id = pa.payroll_action_id

Line 677: pay_payroll_actions pa,

673: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
674: ,rr.run_result_id)
675: ,null) source_text2
676: from pay_assignment_actions aa,
677: pay_payroll_actions pa,
678: pay_run_results rr
679: where aa.ASSIGNMENT_ID = l_assignment_id
680: and aa.assignment_action_id = rr.assignment_action_id
681: and l_action_sequence >= aa.action_sequence

Line 1138: p_date_earned in pay_payroll_actions.date_earned%TYPE,

1134: ---------------------------------------------------------------------------
1135:
1136: function get_retro_period
1137: ( p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1138: p_date_earned in pay_payroll_actions.date_earned%TYPE,
1139: p_call_type in integer -- if 0 then return the period, 1 retro_start, 2 retro_end
1140: ) return varchar2 is
1141:
1142: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

Line 1143: c_date_earned in pay_payroll_actions.date_earned%TYPE

1139: p_call_type in integer -- if 0 then return the period, 1 retro_start, 2 retro_end
1140: ) return varchar2 is
1141:
1142: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1143: c_date_earned in pay_payroll_actions.date_earned%TYPE
1144: ) is
1145: SELECT creator_type
1146: FROM pay_element_entries_f pee
1147: WHERE pee.element_entry_id=c_element_entry_id

Line 1153: c_date_earned in pay_payroll_actions.date_earned%TYPE

1149:
1150:
1151: cursor get_retro_period_rr
1152: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1153: c_date_earned in pay_payroll_actions.date_earned%TYPE
1154: ) is
1155:
1156: SELECT ptp.start_date
1157: ,ptp.end_date

Line 1160: pay_payroll_actions ppa,

1156: SELECT ptp.start_date
1157: ,ptp.end_date
1158: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1159: FROM per_time_periods ptp,
1160: pay_payroll_actions ppa,
1161: pay_assignment_actions paa,
1162: pay_run_results prr,
1163: pay_element_entries_f pee
1164: WHERE pee.element_entry_id=c_element_entry_id

Line 1176: c_date_earned in pay_payroll_actions.date_earned%TYPE

1172:
1173:
1174: cursor get_retro_period_nr
1175: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1176: c_date_earned in pay_payroll_actions.date_earned%TYPE
1177: ) is
1178: SELECT ptp.start_date
1179: ,ptp.end_date
1180: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')

Line 1182: pay_payroll_actions ppa,

1178: SELECT ptp.start_date
1179: ,ptp.end_date
1180: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1181: FROM per_time_periods ptp,
1182: pay_payroll_actions ppa,
1183: pay_assignment_actions paa,
1184: pay_run_results prr,
1185: pay_element_entries_f pee
1186: WHERE pee.element_entry_id=c_element_entry_id

Line 1198: c_date_earned in pay_payroll_actions.date_earned%TYPE

1194:
1195:
1196: cursor get_retro_period_pr
1197: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1198: c_date_earned in pay_payroll_actions.date_earned%TYPE
1199: ) is
1200: SELECT ptp.start_date
1201: ,ptp.end_date
1202: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')

Line 1204: pay_payroll_actions ppa,

1200: SELECT ptp.start_date
1201: ,ptp.end_date
1202: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1203: FROM per_time_periods ptp,
1204: pay_payroll_actions ppa,
1205: pay_assignment_actions paa,
1206: pay_run_results prr,
1207: pay_element_entries_f pee
1208: WHERE pee.element_entry_id=c_element_entry_id

Line 1220: c_date_earned in pay_payroll_actions.date_earned%TYPE

1216:
1217:
1218: cursor get_retro_period_ee
1219: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1220: c_date_earned in pay_payroll_actions.date_earned%TYPE
1221: ) is
1222: SELECT ptp.start_date
1223: ,ptp.end_date
1224: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')

Line 1226: pay_payroll_actions ppa,

1222: SELECT ptp.start_date
1223: ,ptp.end_date
1224: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1225: FROM per_time_periods ptp,
1226: pay_payroll_actions ppa,
1227: pay_assignment_actions paa,
1228: pay_element_entries_f pee
1229: WHERE pee.element_entry_id=c_element_entry_id
1230: and paa.assignment_action_id=pee.source_asg_action_id