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 171: from pay_payroll_actions pa,

167: and p_effective_date between effective_start_date and effective_end_date;
168:
169: cursor csr_get_action_id (asg_id number) is
170: select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
171: from pay_payroll_actions pa,
172: pay_assignment_actions aa,
173: per_time_periods ptp
174: where aa.action_status = 'C'
175: and pa.payroll_action_id = aa.payroll_action_id

Line 303: pay_payroll_actions pa

299: --
300: l_action_type varchar2(2);
301: cursor periodDates is
302: select pa.action_type from
303: pay_payroll_actions pa
304: , pay_assignment_actions aa
305: where pa.payroll_action_id = aa.payroll_action_id
306: and aa.assignment_action_id = p_assignment_action_id;
307:

Line 331: ,pay_payroll_actions pa1

327: ,fnd_date.date_to_displaydate(tp1.start_date) COL02
328: ,tp1.period_type COL07
329: from pay_all_payrolls_f pp1
330: ,pay_all_payrolls_f pp2
331: ,pay_payroll_actions pa1
332: ,pay_payroll_actions pa2
333: ,per_time_periods tp1
334: ,per_time_periods tp2
335: ,pay_assignment_actions aa1

Line 332: ,pay_payroll_actions pa2

328: ,tp1.period_type COL07
329: from pay_all_payrolls_f pp1
330: ,pay_all_payrolls_f pp2
331: ,pay_payroll_actions pa1
332: ,pay_payroll_actions pa2
333: ,per_time_periods tp1
334: ,per_time_periods tp2
335: ,pay_assignment_actions aa1
336: ,pay_assignment_actions aa2

Line 372: from pay_payroll_actions pa

368: ,fnd_date.date_to_displaydate(aa.start_date) COL05
369: ,fnd_date.date_to_displaydate(aa.end_date) COL06
370: ,fnd_date.date_to_displaydate(tp.start_date) COL02
371: ,tp.period_type COL07
372: from pay_payroll_actions pa
373: ,per_time_periods tp
374: ,pay_assignment_actions aa
375: where pa.payroll_action_id = aa.payroll_action_id
376: and pa.effective_date = tp.regular_payment_date

Line 389: from pay_payroll_actions pa

385: ,fnd_date.date_to_displaydate(aa.start_date) COL05
386: ,fnd_date.date_to_displaydate(aa.end_date) COL06
387: ,fnd_date.date_to_displaydate(tp.start_date) COL02
388: ,tp.period_type COL07
389: from pay_payroll_actions pa
390: ,per_time_periods tp
391: ,pay_assignment_actions aa
392: where pa.payroll_action_id = aa.payroll_action_id
393: and pa.time_period_id = tp.time_period_id

Line 532: from pay_payroll_actions pa

528: , aa.assignment_id
529: , pa.business_group_id
530: , bg.legislation_code
531: , lrl.rule_mode
532: from pay_payroll_actions pa
533: , pay_assignment_actions aa
534: , per_business_groups bg
535: , pay_legislation_rules lrl
536: where aa.assignment_action_id = p_assignment_action_id

Line 583: , pay_payroll_actions pa

579: , rb.SOURCE_NUMBER
580: , rb.SOURCE_TEXT2
581: from pay_run_balances rb
582: , pay_assignment_actions aa
583: , pay_payroll_actions pa
584: where rb.ASSIGNMENT_ID = l_assignment_id
585: and l_action_sequence >= aa.action_sequence
586: and rb.assignment_action_id = aa.assignment_action_id
587: and aa.payroll_action_id = pa.payroll_action_id

Line 611: pay_payroll_actions pa,

607: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
608: ,rr.run_result_id)
609: ,null) source_text2
610: from pay_assignment_actions aa,
611: pay_payroll_actions pa,
612: pay_run_results rr
613: where aa.ASSIGNMENT_ID = l_assignment_id
614: and aa.assignment_action_id = rr.assignment_action_id
615: and l_action_sequence >= aa.action_sequence

Line 1063: p_date_earned in pay_payroll_actions.date_earned%TYPE,

1059: ---------------------------------------------------------------------------
1060:
1061: function get_retro_period
1062: ( p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1063: p_date_earned in pay_payroll_actions.date_earned%TYPE,
1064: p_call_type in integer -- if 0 then return the period, 1 retro_start, 2 retro_end
1065: ) return varchar2 is
1066:
1067: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

Line 1068: c_date_earned in pay_payroll_actions.date_earned%TYPE

1064: p_call_type in integer -- if 0 then return the period, 1 retro_start, 2 retro_end
1065: ) return varchar2 is
1066:
1067: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1068: c_date_earned in pay_payroll_actions.date_earned%TYPE
1069: ) is
1070: SELECT creator_type
1071: FROM pay_element_entries_f pee
1072: WHERE pee.element_entry_id=c_element_entry_id

Line 1078: c_date_earned in pay_payroll_actions.date_earned%TYPE

1074:
1075:
1076: cursor get_retro_period_rr
1077: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1078: c_date_earned in pay_payroll_actions.date_earned%TYPE
1079: ) is
1080:
1081: SELECT ptp.start_date
1082: ,ptp.end_date

Line 1085: pay_payroll_actions ppa,

1081: SELECT ptp.start_date
1082: ,ptp.end_date
1083: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1084: FROM per_time_periods ptp,
1085: pay_payroll_actions ppa,
1086: pay_assignment_actions paa,
1087: pay_run_results prr,
1088: pay_element_entries_f pee
1089: WHERE pee.element_entry_id=c_element_entry_id

Line 1101: c_date_earned in pay_payroll_actions.date_earned%TYPE

1097:
1098:
1099: cursor get_retro_period_nr
1100: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1101: c_date_earned in pay_payroll_actions.date_earned%TYPE
1102: ) is
1103: SELECT ptp.start_date
1104: ,ptp.end_date
1105: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')

Line 1107: pay_payroll_actions ppa,

1103: SELECT ptp.start_date
1104: ,ptp.end_date
1105: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1106: FROM per_time_periods ptp,
1107: pay_payroll_actions ppa,
1108: pay_assignment_actions paa,
1109: pay_run_results prr,
1110: pay_element_entries_f pee
1111: WHERE pee.element_entry_id=c_element_entry_id

Line 1123: c_date_earned in pay_payroll_actions.date_earned%TYPE

1119:
1120:
1121: cursor get_retro_period_pr
1122: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1123: c_date_earned in pay_payroll_actions.date_earned%TYPE
1124: ) is
1125: SELECT ptp.start_date
1126: ,ptp.end_date
1127: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')

Line 1129: pay_payroll_actions ppa,

1125: SELECT ptp.start_date
1126: ,ptp.end_date
1127: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1128: FROM per_time_periods ptp,
1129: pay_payroll_actions ppa,
1130: pay_assignment_actions paa,
1131: pay_run_results prr,
1132: pay_element_entries_f pee
1133: WHERE pee.element_entry_id=c_element_entry_id

Line 1145: c_date_earned in pay_payroll_actions.date_earned%TYPE

1141:
1142:
1143: cursor get_retro_period_ee
1144: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
1145: c_date_earned in pay_payroll_actions.date_earned%TYPE
1146: ) is
1147: SELECT ptp.start_date
1148: ,ptp.end_date
1149: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')

Line 1151: pay_payroll_actions ppa,

1147: SELECT ptp.start_date
1148: ,ptp.end_date
1149: ,ptp.period_num || '/' || to_char(ptp.start_date,'YYYY')
1150: FROM per_time_periods ptp,
1151: pay_payroll_actions ppa,
1152: pay_assignment_actions paa,
1153: pay_element_entries_f pee
1154: WHERE pee.element_entry_id=c_element_entry_id
1155: and paa.assignment_action_id=pee.source_asg_action_id