DBA Data[Home] [Help]

APPS.IGF_AW_FUND_CAT_PKG dependencies on IGF_AW_GEN

Line 263: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;

259: || Who When What
260: || (reverse chronological order - newest change first)
261: */
262:
263: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;
264: CURSOR cur_rowid IS
265: SELECT rowid
266: FROM igf_aw_fund_cat_all
267: WHERE fund_code = x_fund_code

Line 303: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;

299: || uniqueness of the alt_loan_code column.
300: || (reverse chronological order - newest change first)
301: */
302:
303: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;
304: CURSOR cur_rowid IS
305: SELECT rowid
306: FROM igf_aw_fund_cat_all
307: WHERE (NVL(alt_loan_code,'*') = NVL(x_alt_loan_code,'**')

Line 374: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;

370: || Who When What
371: || (reverse chronological order - newest change first)
372: */
373:
374: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;
375: CURSOR cur_rowid IS
376: SELECT rowid
377: FROM igf_aw_fund_cat_all
378: WHERE ((fund_type = x_fund_type))

Line 524: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;

520: x_last_update_date DATE;
521: x_last_updated_by NUMBER;
522: x_last_update_login NUMBER;
523:
524: l_org_id igf_aw_fund_cat_all.org_id%TYPE := igf_aw_gen.get_org_id;
525:
526: BEGIN
527:
528: x_last_update_date := SYSDATE;