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 871: ,pay_payroll_actions ppa

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

Line 890: FROM pay_payroll_actions ppa

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

Line 1044: ,pay_payroll_actions ppa

1040: ,TO_CHAR(decode(pet.processing_type,''R'',least(pab.date_end,PTP.END_DATE),pab.date_end),''DD-Mon-YYYY'') COL03
1041: ,TO_CHAR(decode(pet.processing_type,''R'',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours))
1042: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
1043: FROM pay_assignment_actions paa
1044: ,pay_payroll_actions ppa
1045: ,pay_run_results prr
1046: ,pay_run_result_values prrv
1047: ,per_time_periods ptp
1048: ,pay_element_types_f pet

Line 1120: FROM pay_payroll_actions ppa

1116: l_assignment_action_id := p_assignment_action_id;
1117: END IF;
1118:
1119: g_sql := 'SELECT ppa.pay_advice_message COL01
1120: FROM pay_payroll_actions ppa
1121: , pay_assignment_actions paa
1122: WHERE ppa.payroll_action_id = paa.payroll_action_id
1123: AND paa.assignment_action_id = ' || l_assignment_action_id;
1124: