APPS.PAY_US_NACHA_TAPE dependencies on PAY_PRE_PAYMENTS

Line 269: pay_pre_payments ppp

265: pay_run_results prr,
266: pay_payroll_actions ppa,
267: pay_assignment_actions paa,
268: pay_action_interlocks pai,
269: pay_pre_payments ppp
270: WHERE ppp.value = p_amount
271: and ppp.pre_payment_id = p_ppm_id
272: and ppp.assignment_action_id = pai.locking_action_id
273: and pai.locked_action_id = paa.assignment_action_id

Line 337: pay_pre_payments ppp,

333: pay_run_results prr_pay,
334: pay_payroll_actions ppa,
335: pay_assignment_actions paa,
336: pay_action_interlocks pai,
337: pay_pre_payments ppp,
338: pay_input_values_f piv_pay,
339: pay_run_result_values prrv_att,
340: pay_run_result_values prrv_pay
341: WHERE ppp.value = p_amount

Line 397: pay_pre_payments ppp,

393: pay_run_results prr_pay,
394: pay_payroll_actions ppa,
395: pay_assignment_actions paa,
396: pay_action_interlocks pai,
397: pay_pre_payments ppp,
398: pay_input_values_f piv_pay,
399: pay_run_result_values prrv_att,
400: pay_run_result_values prrv_pay,
401: pay_element_types_f pet,

Line 1524: FROM pay_pre_payments ppp, pay_org_payment_methods_f opm,

1520: lr_transact_date_rec csr_get_transact_date%ROWTYPE;
1521:
1522: CURSOR csr_get_batch_no IS
1523: SELECT ppp.org_payment_method_id, hou.organization_id, paa.assignment_action_id
1524: FROM pay_pre_payments ppp, pay_org_payment_methods_f opm,
1525: hr_organization_units hou, hr_organization_information hoi,
1526: pay_payroll_actions ppa, pay_assignment_actions paa
1527: WHERE opm.org_payment_method_id = ppp.org_payment_method_id
1528: AND opm.org_payment_method_id = ppa.org_payment_method_id

Line 1565: ln_org_pay_method_id pay_pre_payments.org_payment_method_id%TYPE := -1;

1561: AND sysdate between flv.start_date_active and nvl(flv.end_date_active, sysdate);
1562:
1563: lr_conc_ident csr_get_conc_ident%ROWTYPE;
1564:
1565: ln_org_pay_method_id pay_pre_payments.org_payment_method_id%TYPE := -1;
1566: ln_org_id hr_organization_units.organization_id%TYPE := -1;
1567: ln_batch_number NUMBER(5) := 0;
1568: lv_return_value VARCHAR2(80) := NULL;
1569: