DBA Data[Home] [Help]

APPS.IGS_FI_GEN_007 dependencies on IGS_FI_INVLN_INT

Line 607: FROM igs_fi_invln_int

603: l_cur_cr_act cur_cr_act%ROWTYPE;
604:
605: CURSOR cur_invln IS
606: SELECT invoice_lines_id
607: FROM igs_fi_invln_int
608: WHERE invoice_id = p_invoice_id;
609: l_cur_invln cur_invln%ROWTYPE;
610:
611: l_rowid VARCHAR2(25):=NULL;

Line 869: p_invoice_lines_id IN igs_fi_invln_int.invoice_lines_id%TYPE,

865: END unapplication;
866:
867:
868: PROCEDURE get_appl_acc(p_cr_activity_id IN igs_fi_cr_activities.credit_activity_id%TYPE,
869: p_invoice_lines_id IN igs_fi_invln_int.invoice_lines_id%TYPE,
870: p_dr_gl_ccid OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
871: p_cr_gl_ccid OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
872: p_dr_account_cd OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
873: p_cr_account_cd OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,

Line 891: FROM igs_fi_invln_int

887: l_cur_cr_act cur_cr_act%ROWTYPE;
888:
889: CURSOR cur_inv IS
890: SELECT rec_gl_ccid,rev_gl_ccid,rec_account_cd,rev_account_cd
891: FROM igs_fi_invln_int
892: WHERE invoice_lines_id = p_invoice_lines_id
893: AND NVL(error_account,'N') <> 'Y';
894: l_cur_inv cur_inv%ROWTYPE;
895: