DBA Data[Home] [Help]

APPS.FV_CCR_UTIL_PVT dependencies on IBY_PMT_INSTR_USES_ALL

Line 2809: UPDATE iby_pmt_instr_uses_all

2805: IF(nvl(p_old_bank_account_id,0)=0 AND nvl(p_vendor_id,0)<>0
2806: AND nvl(p_pay_site_id,0)<>0 AND
2807: (p_valid_bank_info='Y' OR p_federal_vendor='N')) THEN
2808:
2809: UPDATE iby_pmt_instr_uses_all
2810: SET END_DATE=nvl(START_DATE,p_file_date-1),
2811: last_update_date=sysdate,
2812: last_updated_by=l_user_id,
2813: last_update_login=l_login_id

Line 2861: UPDATE iby_pmt_instr_uses_all

2857:
2858: if(l_uses_reln_exists = 'Y') THEN
2859:
2860: IF(l_end_date IS NOT NULL) THEN
2861: UPDATE iby_pmt_instr_uses_all
2862: SET end_date=null,
2863: start_date=p_file_date,
2864: last_update_date = sysdate,
2865: last_updated_by = l_user_id,