APPS.LNS_DISTRIBUTIONS_PUB dependencies on XLA_POST_ACCT_PROGS_B

Line 4158: -- 11-16-2005 added reference to XLA_POST_ACCT_PROGS_B as per

4154: | Cursor Declarations |
4155: +-----------------------------------------------------------------------*/
4156:
4157: -- cursor to establish the loan receivables accounts
4158: -- 11-16-2005 added reference to XLA_POST_ACCT_PROGS_B as per
4159: -- xla team instructions (noela, ayse)
4160: cursor C_ERS_LOAN_RECEIVABLE(p_loan_id number) is
4161: select sum(lline.requested_amount)
4162: ,ael.code_combination_id

Line 4183: ,XLA_POST_ACCT_PROGS_B xpa

4179: and ael.accounting_class_code IN
4180: (select xaa.accounting_class_code
4181: from XLA_ACCT_CLASS_ASSGNS xaa
4182: ,XLA_ASSIGNMENT_DEFNS_B xad
4183: ,XLA_POST_ACCT_PROGS_B xpa
4184: where xaa.program_code = 'GET_RECEIVABLE_CCID'
4185: and xpa.program_code = xaa.program_code
4186: and xaa.program_code = xad.program_code
4187: and xad.assignment_code = xaa.assignment_code

Line 4198: -- 11-16-2005 added reference to XLA_POST_ACCT_PROGS_B as per

4194: and loan_id = p_loan_id)
4195: group by ael.code_combination_id;
4196:
4197: -- cursor to establish the loan clearing accounts
4198: -- 11-16-2005 added reference to XLA_POST_ACCT_PROGS_B as per
4199: -- xla team instructions (noela, ayse)
4200: cursor C_ERS_LOAN_CLEARING(p_loan_id number) is
4201: select sum(ael.entered_dr)
4202: ,ael.code_combination_id

Line 4218: ,XLA_POST_ACCT_PROGS_B xpa

4214: and ael.accounting_class_code in
4215: (select xaa.accounting_class_code
4216: from XLA_ACCT_CLASS_ASSGNS xaa
4217: ,XLA_ASSIGNMENT_DEFNS_B xad
4218: ,XLA_POST_ACCT_PROGS_B xpa
4219: where xaa.program_code = 'LNS_ADJUSTMENT_DEBIT' -- Bug#8231149
4220: and xpa.program_code = xaa.program_code
4221: and xaa.program_code = xad.program_code
4222: and xad.assignment_code = xaa.assignment_code

Line 6608: ,XLA_POST_ACCT_PROGS_B xpa

6604: and ael.accounting_class_code in
6605: (select xaa.accounting_class_code
6606: from XLA_ACCT_CLASS_ASSGNS xaa
6607: ,XLA_ASSIGNMENT_DEFNS_B xad
6608: ,XLA_POST_ACCT_PROGS_B xpa
6609: where xaa.program_code = 'LNS_ADJUSTMENT_DEBIT' -- Bug#8231149
6610: and xpa.program_code = xaa.program_code
6611: and xaa.program_code = xad.program_code
6612: and xad.assignment_code = xaa.assignment_code

Line 6640: ,XLA_POST_ACCT_PROGS_B xpa

6636: and ael.accounting_class_code IN
6637: (select xaa.accounting_class_code
6638: from XLA_ACCT_CLASS_ASSGNS xaa
6639: ,XLA_ASSIGNMENT_DEFNS_B xad
6640: ,XLA_POST_ACCT_PROGS_B xpa
6641: where xaa.program_code = 'GET_RECEIVABLE_CCID'
6642: and xpa.program_code = xaa.program_code
6643: and xaa.program_code = xad.program_code
6644: and xad.assignment_code = xaa.assignment_code