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

Line 54: p_pre_payment_id pay_pre_payments.pre_payment_id%TYPE

50: p_date_earned pay_payroll_actions.date_earned%TYPE
51: DEFAULT NULL,
52: p_override_date pay_payroll_actions.overriding_dd_date%TYPE
53: DEFAULT NULL,
54: p_pre_payment_id pay_pre_payments.pre_payment_id%TYPE
55: DEFAULT NULL,
56: p_payment_date pay_payroll_actions.effective_date%TYPE
57: DEFAULT NULL
58: )

Line 114: pay_pre_payments ppp

110: pay_assignment_actions paa_chk,
111: pay_payroll_actions ppa_pre,
112: pay_assignment_actions paa_pre,
113: pay_action_interlocks pai,
114: pay_pre_payments ppp
115: WHERE ppa_chk.payroll_action_id = cp_payroll_action_id
116: AND ppa_chk.business_group_id = cp_business_group_id
117: AND ppa_chk.payroll_id = NVL (cp_payroll_id, ppa_chk.payroll_id)
118: AND ppa_chk.consolidation_set_id =

Line 148: FROM pay_pre_payments ppp,

144: *************************************************************************/
145: CURSOR c_get_pymt_date_with_prepay_id (cp_pre_payment_id IN NUMBER)
146: IS
147: SELECT ppa.effective_date
148: FROM pay_pre_payments ppp,
149: pay_assignment_actions paa,
150: pay_payroll_actions ppa
151: WHERE ppp.pre_payment_id = cp_pre_payment_id
152: AND ppp.assignment_action_id = paa.assignment_action_id