DBA Data[Home] [Help]

APPS.IGS_FI_GEN_001 dependencies on IGF_AW_AWD_DISB

Line 1614: igf_aw_awd_disb disb,

1610: CURSOR c_sum_pln_bw_dates IS
1611: SELECT
1612: SUM(disb.disb_net_amt )
1613: FROM
1614: igf_aw_awd_disb disb,
1615: igf_aw_award awd,
1616: igf_aw_fund_mast fmast,
1617: igf_ap_fa_base_rec base,
1618: igf_ap_batch_aw_map bm

Line 1635: igf_aw_awd_disb disb,

1631: CURSOR c_sum_pln_till_date IS
1632: SELECT
1633: SUM(disb.disb_net_amt )
1634: FROM
1635: igf_aw_awd_disb disb,
1636: igf_aw_award awd,
1637: igf_aw_fund_mast fmast,
1638: igf_ap_fa_base_rec base,
1639: igf_ap_batch_aw_map bm

Line 1653: l_n_sum_pln_credits igf_aw_awd_disb.disb_net_amt%TYPE;

1649: AND TRUNC(disb.disb_date) <= TRUNC(p_end_date)
1650: AND bm.award_year_status_code = 'O';
1651:
1652: l_n_person_id igs_fi_parties_v.person_id%TYPE;
1653: l_n_sum_pln_credits igf_aw_awd_disb.disb_net_amt%TYPE;
1654:
1655: BEGIN
1656:
1657: IF (p_person_id IS NULL OR p_end_date IS NULL) THEN