APPS.JAI_FBT_SETTLEMENT_P dependencies on JAI_FBT_REPOSITORY

Line 35: -- In: p_fbt_settlement jai_fbt_repository record type

31: --
32: -- This procedure is to insert the data into jai_fbt_settlement
33: --
34: -- PARAMETERS:
35: -- In: p_fbt_settlement jai_fbt_repository record type
36: --
37: -- DESIGN REFERENCES:
38: -- FBT Technical Design Document 1.1.doc
39: --

Line 331: FROM jai_fbt_repository

327:
328: CURSOR cummulative_tax_cur IS
329: SELECT SUM(fbt_tax_amount) + SUM(fbt_surcharge_amount)
330: + SUM(fbt_edu_cess_amount) + SUM(fbt_sh_cess_amount)
331: FROM jai_fbt_repository
332: WHERE legal_entity_id = pn_legal_entity_id
333: AND period_start_date = ld_start_date
334: AND period_end_date = ld_end_date;
335:

Line 460: -- update all the transactions in the jai_fbt_repository

456: fbt_settlement_rec.settlement_id := ln_settlement_id;
457:
458: Insert_Fbt_Settlement(fbt_settlement_rec);
459:
460: -- update all the transactions in the jai_fbt_repository
461: -- with the settlement_id created above
462:
463: UPDATE jai_fbt_repository
464: SET settlement_id = ln_settlement_id

Line 463: UPDATE jai_fbt_repository

459:
460: -- update all the transactions in the jai_fbt_repository
461: -- with the settlement_id created above
462:
463: UPDATE jai_fbt_repository
464: SET settlement_id = ln_settlement_id
465: WHERE legal_entity_id = pn_legal_entity_id
466: AND period_start_date = ld_start_date
467: AND period_end_date = ld_end_date;