eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_BILL_EXTRACT dependencies on IGS_PE_PERSID_GROUP

Line 32: --pathipat 23-Jun-2003 Bug: 3018104 - Impact of igs_pe_persid_group change

28: --smvk 05-Sep-2003 Enh#3045007. Created local procedure create_payplan_bills and its call in billing_extract
29: --schodava 25-Aug-2003 Bug #3021943 - Cut off Date parameter issue.
30: --shtatiko 21-AUG-2003 Bug# 3106262, modified bill_the_person.
31: --vvutukur 18-ul-2003 Enh#3038511.FICR106 Build. Modified procedure bill_the_person.
32: --pathipat 23-Jun-2003 Bug: 3018104 - Impact of igs_pe_persid_group change
33: -- Modified cur_person_id_group
34: --pathipat 23-Apr-2003 Enh 2831569 - Commercial Receivables build - Modified billing_extract()
35: -- Added validation for manage_account - call to chk_manage_account()
36: --shtatiko 12-DEC-2002 Enh Bug#, 2584741 (Deposits), Modified bill_the_person to include Deposit records in report.

Line 131: --pathipat 23-Jun-2003 Bug: 3018104 - Impact of igs_pe_persid_group change

127: --pathipat 06-May-2004 Bug# 3578249 - Modified cursor cur_bill_to_addr_usage
128: --vvutukur 20-Jan-2004 Bug#3348787.Modified cursor cur_bill_to_addr_usage.
129: --schodava 25-Aug-2003 Bug #3021943 - Cut off Date parameter issue.
130: -- Modified cursor CUR_PERSON_IDS
131: --pathipat 23-Jun-2003 Bug: 3018104 - Impact of igs_pe_persid_group change
132: -- Modified cur_person_id_group - replaced igs_pe_persid_group_v
133: -- with igs_pe_persid_group
134: --gmaheswa 12-Nov-2003 Bug: 3227107 - Modified cur_remit_addr cursor to check active status of the records.
135: ------------------------------------------------------------------

Line 132: -- Modified cur_person_id_group - replaced igs_pe_persid_group_v

128: --vvutukur 20-Jan-2004 Bug#3348787.Modified cursor cur_bill_to_addr_usage.
129: --schodava 25-Aug-2003 Bug #3021943 - Cut off Date parameter issue.
130: -- Modified cursor CUR_PERSON_IDS
131: --pathipat 23-Jun-2003 Bug: 3018104 - Impact of igs_pe_persid_group change
132: -- Modified cur_person_id_group - replaced igs_pe_persid_group_v
133: -- with igs_pe_persid_group
134: --gmaheswa 12-Nov-2003 Bug: 3227107 - Modified cur_remit_addr cursor to check active status of the records.
135: ------------------------------------------------------------------
136: --

Line 133: -- with igs_pe_persid_group

129: --schodava 25-Aug-2003 Bug #3021943 - Cut off Date parameter issue.
130: -- Modified cursor CUR_PERSON_IDS
131: --pathipat 23-Jun-2003 Bug: 3018104 - Impact of igs_pe_persid_group change
132: -- Modified cur_person_id_group - replaced igs_pe_persid_group_v
133: -- with igs_pe_persid_group
134: --gmaheswa 12-Nov-2003 Bug: 3227107 - Modified cur_remit_addr cursor to check active status of the records.
135: ------------------------------------------------------------------
136: --
137: -- Parameter Explanation :

Line 162: FROM igs_pe_persid_group

158: CURSOR cur_person_id_group (
159: cp_n_prsid_grp_id IN NUMBER
160: ) IS
161: SELECT 'Y' found_person_id_group
162: FROM igs_pe_persid_group
163: WHERE group_id = cp_n_prsid_grp_id
164: AND closed_ind = 'N'
165: AND TRUNC(creation_date) <= TRUNC(SYSDATE);
166: