APPS.IGC_CC_MPFS_PROCESS_PKG dependencies on GL_SETS_OF_BOOKS

Line 48: gl_sets_of_books gsob

44: -- Define cursor to extract the fiscal year for p_date
45: CURSOR c_fiscal_year(p_sob_id NUMBER) IS
46: SELECT period_year
47: FROM gl_periods gp,
48: gl_sets_of_books gsob
49: WHERE gp.period_set_name = gsob.period_set_name
50: AND gp.period_type = gsob.accounted_period_type
51: AND trunc(p_date) BETWEEN trunc(gp.start_date)
52: AND trunc(gp.end_date)

Line 834: gl_sets_of_books gb,

830: SELECT gps.closing_status
831: INTO l_period_status
832: FROM gl_period_statuses gps,
833: gl_periods gp,
834: gl_sets_of_books gb,
835: gl_period_types gpt,
836: fnd_application fa
837: WHERE
838: gb.set_of_books_id = p_sob_id1 AND

Line 890: gl_sets_of_books gb

886: SELECT ccp.cc_period_status
887: INTO l_cc_period_status
888: FROM igc_cc_periods ccp,
889: gl_periods gp ,
890: gl_sets_of_books gb
891: WHERE
892: ccp.period_set_name = gp.period_set_name AND
893: gp.period_set_name = gb.period_set_name AND
894: ccp.org_id = p_org_id AND

Line 2251: l_currency_code gl_sets_of_books.currency_code%TYPE;

2247: v5 c5%ROWTYPE;
2248: --V6 C6%ROWTYPE;
2249: v7 c7%ROWTYPE;
2250: /*************** ENCUMBRANCE CHECK DECLARATION ****************************/
2251: l_currency_code gl_sets_of_books.currency_code%TYPE;
2252: l_sbc_on BOOLEAN;
2253: l_cbc_on BOOLEAN;
2254: l_prov_enc_on BOOLEAN;
2255: l_conf_enc_on BOOLEAN;