DBA Data[Home] [Help]

APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_THHOLD_XCEPS

Line 3006: cv_tan_no JAI_AP_TDS_THHOLD_XCEPS.org_tan%type,

3002:
3003: CURSOR chk_prospective(
3004: cn_threshold_hdr_id number,
3005: cn_vendor_id number,
3006: cv_tan_no JAI_AP_TDS_THHOLD_XCEPS.org_tan%type,
3007: cv_pan_no JAI_AP_TDS_THHOLD_XCEPS.vendor_pan%type
3008: )
3009: IS
3010: SELECT

Line 3007: cv_pan_no JAI_AP_TDS_THHOLD_XCEPS.vendor_pan%type

3003: CURSOR chk_prospective(
3004: cn_threshold_hdr_id number,
3005: cn_vendor_id number,
3006: cv_tan_no JAI_AP_TDS_THHOLD_XCEPS.org_tan%type,
3007: cv_pan_no JAI_AP_TDS_THHOLD_XCEPS.vendor_pan%type
3008: )
3009: IS
3010: SELECT
3011: PROSPECTIVE_FLAG

Line 3012: FROM JAI_AP_TDS_THHOLD_XCEPS

3008: )
3009: IS
3010: SELECT
3011: PROSPECTIVE_FLAG
3012: FROM JAI_AP_TDS_THHOLD_XCEPS
3013: WHERE THRESHOLD_HDR_ID = cn_threshold_hdr_id
3014: AND VENDOR_ID = cn_vendor_id
3015: AND ORG_TAN = cv_tan_no
3016: AND VENDOR_PAN = cv_pan_no;