APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_BILL_BOND_ISSUES_V

Line 1487: from xtr_bill_bond_issues_v

1483: return false;
1484: end if;
1485: select count(*)
1486: into l_count
1487: from xtr_bill_bond_issues_v
1488: where ni_or_bond='NI'
1489: and issue_date is null
1490: and status is null
1491: and serial_number=p_serial_number;

Line 2645: from xtr_bill_bond_issues_v

2641: l_bank_code XTR_BANK_ACCOUNTS_V.BANK_CODE%TYPE;
2642:
2643: cursor get_bank_issue_code(p_serial_number in NUMBER) is
2644: select bank_code
2645: from xtr_bill_bond_issues_v
2646: where ni_or_bond='NI'
2647: and serial_number=p_serial_number;
2648:
2649:

Line 3191: update XTR_bill_bond_issues_V

3187: open get_bank_issue_code(G_Ni_Parcel_Rec(i).SERIAL_NUMBER);
3188: fetch get_bank_issue_code into G_Ni_Parcel_Rec(i).ISSUE_BANK;
3189: close get_bank_issue_code;
3190:
3191: update XTR_bill_bond_issues_V
3192: set issue_date = G_Ni_Main_Rec.DEAL_DATE,
3193: deal_number = G_Ni_Main_Rec.DEAL_NO,
3194: status = G_Ni_Parcel_Rec(i).STATUS_CODE,
3195: parcel_split_no = G_Ni_Parcel_Rec(i).PARCEL_SPLIT_NO,