APPS.FV_TREASURY_PAYMENTS_PKG dependencies on AP_CHECKS_ALL

Line 11: g_checkrun_name ap_checks_all.checkrun_name%TYPE;

7: g_org_id fv_operating_units.org_id%TYPE;
8: g_treasury_conf_id fv_treasury_confirmations.treasury_confirmation_id%TYPE;
9: g_accounting_date fv_treasury_confirmations.treasury_doc_date%TYPE;
10: g_payment_instr_id iby_pay_instructions_all.payment_instruction_id%TYPE;
11: g_checkrun_name ap_checks_all.checkrun_name%TYPE;
12: x_err_code NUMBER;
13: x_err_stage VARCHAR2(2000);
14: g_dit_flag VARCHAR2(1);
15: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 488: FROM ap_checks_all ac

484: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
485: 'Treasury Confirmation Successful. Checking for Voided Checks');
486:
487: SELECT COUNT(ac.check_id) INTO l_void_count
488: FROM ap_checks_all ac
489: ,fv_treasury_confirmations_all ftc
490: WHERE ftc.treasury_confirmation_id = g_treasury_conf_id
491: AND ftc.payment_instruction_id = ac.payment_instruction_id
492: AND ac.org_id = g_org_id

Line 528: FROM ap_checks_all ac,

524: fnd_global.user_id,
525: fnd_global.login_id,
526: ac.org_id,
527: g_payment_instr_id
528: FROM ap_checks_all ac,
529: fv_treasury_confirmations_all fvc
530: WHERE ac.org_id = g_org_id
531: AND fvc.org_id = ac.org_id
532: AND fvc.treasury_confirmation_id= g_treasury_conf_id

Line 574: ap_checks_all ac

570: WHERE processed_flag = 'U'
571: AND org_id = g_org_id
572: and check_id in ( select check_id
573: from fv_treasury_confirmations_all fvtreas ,
574: ap_checks_all ac
575: where
576: fvtreas.org_id = g_org_id
577: and ac.org_id = fvtreas.org_id
578: and fvtreas.treasury_confirmation_id = g_treasury_conf_id

Line 702: ap_checks_all ac

698: FVC.check_id,
699: FTC.treasury_confirmation_id
700: FROM fv_voided_checks FVC,
701: fv_treasury_confirmations_all FTC,
702: ap_checks_all ac
703: WHERE
704: ftc.org_id = g_org_id
705: AND FVC.org_id = ftc.org_id
706: AND ac.org_id = FVC.org_id

Line 976: FROM fv_voided_checks fvc , ap_checks_all apchk,fv_treasury_confirmations_all fvtreas

972:
973: CURSOR cur_treas_conf
974: IS
975: SELECT max(fvtreas.TREASURY_CONFIRMATION_ID) TREASURY_CONFIRMATION_ID
976: FROM fv_voided_checks fvc , ap_checks_all apchk,fv_treasury_confirmations_all fvtreas
977: WHERE
978: apchk.org_id = g_org_id
979: AND apchk.org_id = fvtreas.org_id
980: AND apchk.check_id = fvc.check_id

Line 1027: FROM ap_checks_all ac,

1023: SYSDATE,
1024: fnd_global.user_id,
1025: fnd_global.login_id,
1026: ac.org_id
1027: FROM ap_checks_all ac,
1028: fv_treasury_confirmations_all fvtc
1029: WHERE ac.org_id = g_org_id
1030: AND fvtc.org_id = ac.org_id
1031: AND fvtc.payment_instruction_id = ac.payment_instruction_id

Line 1059: FROM ap_checks_all ac

1055:
1056: l_void_count:=0;
1057:
1058: SELECT COUNT(ac.check_id) INTO l_void_count
1059: FROM ap_checks_all ac
1060: ,fv_treasury_confirmations_all ftc
1061: , fv_voided_checks fvc
1062: WHERE ftc.treasury_confirmation_id = treas_conf_rec.TREASURY_CONFIRMATION_ID
1063: AND ftc.payment_instruction_id = ac.payment_instruction_id

Line 1087: ap_checks_all ac

1083: WHERE processed_flag = 'U'
1084: AND org_id = g_org_id
1085: and check_id in ( select check_id
1086: from fv_treasury_confirmations_all fvtreas ,
1087: ap_checks_all ac
1088: where
1089: fvtreas.org_id = g_org_id
1090: and ac.org_id = fvtreas.org_id
1091: and fvtreas.treasury_confirmation_id = treas_conf_rec.TREASURY_CONFIRMATION_ID