DBA Data[Home] [Help]

APPS.PA_PAY_INTERFACE dependencies on PA_PAY_REJECTION_PRIORITY

Line 5748: FROM pa_pay_rejection_priority

5744: BEGIN
5745: SELECT REJECTION_CODE
5746: INTO
5747: l_rejection_code
5748: FROM pa_pay_rejection_priority
5749: WHERE PRIORITY = (
5750: SELECT
5751: MIN(pprp.priority)
5752: FROM

Line 5754: pa_pay_rejection_priority pprp

5750: SELECT
5751: MIN(pprp.priority)
5752: FROM
5753: PA_PAY_REJECTIONS_ALL ppr ,
5754: pa_pay_rejection_priority pprp
5755: WHERE
5756: ppr.interface_run_id = p_interface_run_id AND
5757: ppr.person_id = p_person_id AND
5758: ( (p_int_ext_indicator = 'INT' AND (ppr.pay_element_type_id = p_pay_element_type_id )

Line 5800: PA_PAY_REJECTION_PRIORITY PPRP

5796: PPR.REJECTION_CODE,
5797: MAX(PPRP.PRIORITY) PRTY
5798: FROM
5799: PA_PAY_REJECTIONS_ALL PPR ,
5800: PA_PAY_REJECTION_PRIORITY PPRP
5801: WHERE
5802: PPR.INTERFACE_RUN_ID = P_INTERFACE_RUN_ID AND
5803: PPR.PERSON_ID = P_PERSON_ID AND
5804: ( (p_int_ext_indicator = 'INT' AND (ppr.pay_element_type_id = p_pay_element_type_id )