APPS.IGS_FI_POSTING_PROCESS dependencies on IGS_FI_CREDITS

Line 363: FROM igs_fi_credits

359:
360: -- Get the Currency Code from the Credit table with the given credit id.
361: CURSOR cur_credit (cp_credit_id igs_fi_cr_activities.credit_id%TYPE ) IS
362: SELECT currency_cd
363: FROM igs_fi_credits
364: WHERE credit_id = cp_credit_id;
365:
366: l_b_exception_flag BOOLEAN := FALSE;
367:

Line 368: l_v_currency_cd igs_fi_credits.currency_cd%TYPE;

364: WHERE credit_id = cp_credit_id;
365:
366: l_b_exception_flag BOOLEAN := FALSE;
367:
368: l_v_currency_cd igs_fi_credits.currency_cd%TYPE;
369: l_v_cr_account_cd igs_fi_cr_activities.cr_account_cd%TYPE;
370: l_v_dr_account_cd igs_fi_cr_activities.dr_account_cd%TYPE;
371: l_n_amount igs_fi_cr_activities.amount%TYPE;
372:

Line 530: FROM igs_fi_credits

526:
527: -- Get the details like Effective date and Currency Code from the Credit table with the given credit id.
528: CURSOR cur_credit (cp_credit_id igs_fi_applications.credit_id%TYPE ) IS
529: SELECT currency_cd
530: FROM igs_fi_credits
531: WHERE credit_id = cp_credit_id;
532:
533:
534: l_b_exception_flag BOOLEAN := FALSE;

Line 541: l_v_currency_cd igs_fi_credits.currency_cd%TYPE;

537: l_v_dr_account_cd igs_fi_applications.dr_account_cd%TYPE;
538: l_n_amount igs_fi_applications.amount_applied%TYPE;
539: l_v_posting_rowid ROWID;
540: l_n_posting_id igs_fi_posting_int.posting_id%TYPE;
541: l_v_currency_cd igs_fi_credits.currency_cd%TYPE;
542:
543: BEGIN
544:
545:

Line 1029: FROM igs_fi_credits crd,

1025:
1026: --Cursor to fetch the credit number for the passed credit_id
1027: CURSOR cur_credit(cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS
1028: SELECT crd.credit_number
1029: FROM igs_fi_credits crd,
1030: igs_fi_cr_activities cra
1031: WHERE cra.credit_activity_id = cp_transaction_id
1032: AND crd.credit_id = cra.credit_id;
1033:

Line 1039: igs_fi_credits crd,

1035: CURSOR cur_appl(cp_transaction_id IN igs_fi_posting_int_all.source_transaction_id%TYPE) IS
1036: SELECT crd.credit_number,
1037: inv.invoice_number
1038: FROM igs_fi_applications app,
1039: igs_fi_credits crd,
1040: igs_fi_inv_int inv
1041: WHERE application_id = cp_transaction_id
1042: AND app.credit_id = crd.credit_id
1043: AND app.invoice_id = inv.invoice_id;

Line 1047: l_v_credit_number igs_fi_credits.credit_number%TYPE;

1043: AND app.invoice_id = inv.invoice_id;
1044:
1045: l_v_comments ra_interface_lines_all.comments%TYPE := NULL;
1046: l_v_invoice_number igs_fi_inv_int.invoice_number%TYPE;
1047: l_v_credit_number igs_fi_credits.credit_number%TYPE;
1048:
1049: BEGIN
1050: -- Setup the comments with the passes transaction types meaning and colon :
1051: l_v_comments := lookup_desc('IGS_FI_SOURCE_TRANSACTION_TYPE',p_transaction_type)||':';