APPS.XTR_XTRLTDAP_XMLP_PKG dependencies on XTR_SETTLEMENT_SCRIPTS_V

Line 46: XTR_SETTLEMENT_SCRIPTS_V

42: IF (P_DISPLAY_DEBUG = 'Y') THEN
43: NULL;
44: END IF;
45: UPDATE
46: XTR_SETTLEMENT_SCRIPTS_V
47: SET
48: LAST_RUN_ON = TO_DATE(PERIOD_FROM_DATE
49: ,'DD/MM/YYYY')
50: ,RUN_REQUESTED_ON = NULL

Line 81: XTR_SETTLEMENT_SCRIPTS_V S

77: SELECT
78: B.ACCOUNT_NUMBER
79: FROM
80: XTR_BANK_ACCOUNTS_V B,
81: XTR_SETTLEMENT_SCRIPTS_V S
82: WHERE B.ACCOUNT_NUMBER = A.ACCOUNT_NO
83: AND B.ACCOUNT_NUMBER like NVL(UPPER(ACCOUNT_NUMBER)
84: ,'%')
85: AND B.PARTY_CODE like NVL(UPPER(COMP_CODE)