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

Line 35: , pay_payroll_actions ppa

31: ,hr_organization_information hoi
32: ,hr_organization_units hou
33: ,hr_organization_information hoi2
34: , pay_assignment_actions paa
35: , pay_payroll_actions ppa
36: WHERE
37: paa.assignment_action_id = p_assignment_action_id
38: AND paa.payroll_action_id = ppa.payroll_action_id
39: AND peaf.assignment_id = paa.assignment_id

Line 194: pay_payroll_actions pa

190: l_action_type VARCHAR2(2);
191:
192: CURSOR periodDates IS
193: SELECT action_type FROM
194: pay_payroll_actions pa
195: ,per_time_periods tp
196: ,pay_assignment_actions aa
197: WHERE pa.payroll_action_id = aa.payroll_action_id
198: AND pa.effective_date = tp.regular_payment_date

Line 221: from pay_payroll_actions pa1

217: ,fnd_date.date_to_displaydate(tp2.end_date) COL04
218: ,fnd_date.date_to_displaydate(aa1.start_date) COL05
219: ,fnd_date.date_to_displaydate(aa2.end_date) COL06
220: ,tp1.period_type COL07
221: from pay_payroll_actions pa1
222: ,pay_payroll_actions pa2
223: ,per_time_periods tp1
224: ,per_time_periods tp2
225: ,pay_assignment_actions aa1

Line 222: ,pay_payroll_actions pa2

218: ,fnd_date.date_to_displaydate(aa1.start_date) COL05
219: ,fnd_date.date_to_displaydate(aa2.end_date) COL06
220: ,tp1.period_type COL07
221: from pay_payroll_actions pa1
222: ,pay_payroll_actions pa2
223: ,per_time_periods tp1
224: ,per_time_periods tp2
225: ,pay_assignment_actions aa1
226: ,pay_assignment_actions aa2

Line 244: from pay_payroll_actions pa

240: ,fnd_date.date_to_displaydate(aa.start_date) COL05
241: ,fnd_date.date_to_displaydate(aa.end_date) COL06
242: ,fnd_date.date_to_displaydate(tp.start_date) COL02
243: ,tp.period_type COL07
244: from pay_payroll_actions pa
245: ,per_time_periods tp
246: ,pay_assignment_actions aa
247: where pa.payroll_action_id = aa.payroll_action_id
248: and pa.effective_date = tp.regular_payment_date

Line 261: from pay_payroll_actions pa

257: ,fnd_date.date_to_displaydate(aa.start_date) COL05
258: ,fnd_date.date_to_displaydate(aa.end_date) COL06
259: ,fnd_date.date_to_displaydate(tp.start_date) COL02
260: ,tp.period_type COL07
261: from pay_payroll_actions pa
262: ,per_time_periods tp
263: ,pay_assignment_actions aa
264: where pa.payroll_action_id = aa.payroll_action_id
265: and pa.time_period_id = tp.time_period_id

Line 718: FROM pay_payroll_actions ppa

714:
715: CURSOR csr_get_bg_id
716: IS
717: SELECT ppa.business_group_id
718: FROM pay_payroll_actions ppa
719: ,pay_assignment_actions paa
720: WHERE ppa.payroll_action_id = paa.payroll_action_id
721: AND paa.assignment_action_id = p_assignment_action_id;
722:

Line 788: FROM pay_payroll_actions ppa

784:
785: CURSOR csr_get_date_earned
786: IS
787: SELECT ppa.date_earned, ppa.business_group_id
788: FROM pay_payroll_actions ppa
789: , pay_assignment_actions paa
790: WHERE ppa.payroll_action_id = paa.payroll_action_id
791: AND paa.assignment_action_id = p_assignment_action_id;
792:

Line 799: , pay_payroll_actions ppa

795: SELECT hsck.segment1
796: FROM hr_soft_coding_keyflex hsck
797: , per_assignments_f paf
798: , pay_assignment_actions paa
799: , pay_payroll_actions ppa
800: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
801: AND paa.assignment_action_id = p_assignment_action_id
802: AND paa.payroll_action_id = ppa.payroll_action_id
803: AND paf.assignment_id = paa.assignment_id

Line 868: ,pay_payroll_actions ppa

864: ,pay_element_types_f pet
865: ,pay_element_links_f pel
866: ,pay_element_entries_f pee
867: ,pay_assignment_actions paa
868: ,pay_payroll_actions ppa
869: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
870: AND pel.element_type_id = pet.element_type_id
871: AND pee.element_link_id = pel.element_link_id
872: AND paa.assignment_id = pee.assignment_id

Line 887: FROM pay_payroll_actions ppa

883:
884: CURSOR csr_get_date_earned
885: IS
886: SELECT ppa.date_earned
887: FROM pay_payroll_actions ppa
888: , pay_assignment_actions paa
889: WHERE ppa.payroll_action_id = paa.payroll_action_id
890: AND paa.assignment_action_id = p_assignment_action_id;
891:

Line 1024: ,pay_payroll_actions ppa

1020: ,TO_CHAR(decode(pet.processing_type,''R'',least(pab.date_end,PTP.END_DATE),pab.date_end),''DD-Mon-YYYY'') COL03
1021: ,TO_CHAR(decode(pet.processing_type,''R'',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours))
1022: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
1023: FROM pay_assignment_actions paa
1024: ,pay_payroll_actions ppa
1025: ,pay_run_results prr
1026: ,pay_run_result_values prrv
1027: ,per_time_periods ptp
1028: ,pay_element_types_f pet

Line 1100: FROM pay_payroll_actions ppa

1096: l_assignment_action_id := p_assignment_action_id;
1097: END IF;
1098:
1099: g_sql := 'SELECT ppa.pay_advice_message COL01
1100: FROM pay_payroll_actions ppa
1101: , pay_assignment_actions paa
1102: WHERE ppa.payroll_action_id = paa.payroll_action_id
1103: AND paa.assignment_action_id = ' || l_assignment_action_id;
1104: