APPS.IGS_FI_GL_INTERFACE dependencies on IGS_FI_CR_ACTIVITIES

Line 533: FROM igs_fi_cr_activities cra,

529: cp_gl_date_end DATE) IS
530: SELECT cra.rowid,cra.*,
531: crd.credit_number credit_number,
532: crd.party_id party_id
533: FROM igs_fi_cr_activities cra,
534: igs_fi_credits crd
535: WHERE cra.gl_date IS NOT NULL
536: AND ((cra.POSTING_ID IS NULL) AND (cra.POSTING_CONTROL_ID IS NULL))
537: AND TRUNC(cra.gl_date) >= TRUNC(cp_gl_date_start)

Line 588: p_ref30 => 'IGS_FI_CR_ACTIVITIES',

584: p_dr_ccid => crdrec.dr_gl_ccid,
585: p_cr_ccid => crdrec.cr_gl_ccid,
586: p_amount => crdrec.amount,
587: p_ref23 => crdrec.credit_activity_id,
588: p_ref30 => 'IGS_FI_CR_ACTIVITIES',
589: p_desc => l_v_crd_desc);
590: EXCEPTION
591: WHEN OTHERS THEN
592: l_b_exception_flag := TRUE;

Line 599: igs_fi_cr_activities_pkg.update_row(x_rowid => crdrec.rowid,

595: END;
596:
597: -- Update the Credit Activity record with the batch identifier generated the posted date.
598: IF NOT l_b_exception_flag THEN
599: igs_fi_cr_activities_pkg.update_row(x_rowid => crdrec.rowid,
600: x_credit_activity_id => crdrec.credit_activity_id,
601: x_credit_id => crdrec.credit_id,
602: x_status => crdrec.status,
603: x_transaction_date => crdrec.transaction_date,