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_US_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_PRE_PAYMENTS

Line 209: pay_pre_payments ppp

205: ,cp_legislation_code varchar2) is
206: select ppp.pre_payment_id
207: from pay_payment_types ppt,
208: pay_org_payment_methods_f popm,
209: pay_pre_payments ppp
210: where ppp.assignment_action_id = cp_assignment_action_id
211: and popm.org_payment_method_id = ppp.org_payment_method_id
212: and popm.defined_balance_id is not null
213: and ppt.payment_type_id = popm.payment_type_id

Line 292: from pay_pre_payments ppp

288: select 1
289: from dual
290: where not exists
291: (select 1
292: from pay_pre_payments ppp
293: where ppp.assignment_action_id = cp_prepayment_action_id
294: );
295:
296: lv_reversal_exists VARCHAR2(1);

Line 463: pay_pre_payments ppp

459: (cp_assignment_action_id number) is
460: select ppp.pre_payment_id
461: from pay_payment_types ppt,
462: pay_org_payment_methods_f popm,
463: pay_pre_payments ppp
464: where ppp.assignment_action_id = cp_assignment_action_id
465: and popm.org_payment_method_id = ppp.org_payment_method_id
466: and popm.defined_balance_id is not null
467: and ppt.payment_type_id = popm.payment_type_id;

Line 1123: from pay_pre_payments ppp,

1119: ,cp_pre_payment_id in number) is
1120: select decode(ppa_pymt.action_type,
1121: 'M', to_char(NVL(ppp.source_action_id,cp_pre_payment_action)),
1122: paa_pymt.serial_number)
1123: from pay_pre_payments ppp,
1124: pay_assignment_actions paa_pymt,
1125: pay_payroll_actions ppa_pymt,
1126: pay_action_interlocks pai
1127: where pai.locked_action_id = cp_pre_payment_action