APPS.LNS_DISTRIBUTIONS_PUB dependencies on XLA_POST_ACCT_PROGS_B

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

3325: | Cursor Declarations |
3326: +-----------------------------------------------------------------------*/
3327:
3328: -- cursor to establish the loan receivables accounts
3329: -- 11-16-2005 added reference to XLA_POST_ACCT_PROGS_B as per
3330: -- xla team instructions (noela, ayse)
3331: cursor C_ERS_LOAN_RECEIVABLE(p_loan_id number) is
3332: select sum(ael.entered_dr)
3333: ,ael.code_combination_id

Line 3349: ,XLA_POST_ACCT_PROGS_B xpa

3345: and ael.accounting_class_code IN
3346: (select xaa.accounting_class_code
3347: from XLA_ACCT_CLASS_ASSGNS xaa
3348: ,XLA_ASSIGNMENT_DEFNS_B xad
3349: ,XLA_POST_ACCT_PROGS_B xpa
3350: where xaa.program_code = 'GET_RECEIVABLE_CCID'
3351: and xpa.program_code = xaa.program_code
3352: and xaa.program_code = xad.program_code
3353: and xad.assignment_code = xaa.assignment_code

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

3360: and loan_id = p_loan_id)
3361: group by ael.code_combination_id;
3362:
3363: -- cursor to establish the loan clearing accounts
3364: -- 11-16-2005 added reference to XLA_POST_ACCT_PROGS_B as per
3365: -- xla team instructions (noela, ayse)
3366: cursor C_ERS_LOAN_CLEARING(p_loan_id number) is
3367: select sum(ael.entered_dr)
3368: ,ael.code_combination_id

Line 3384: ,XLA_POST_ACCT_PROGS_B xpa

3380: and ael.accounting_class_code in
3381: (select xaa.accounting_class_code
3382: from XLA_ACCT_CLASS_ASSGNS xaa
3383: ,XLA_ASSIGNMENT_DEFNS_B xad
3384: ,XLA_POST_ACCT_PROGS_B xpa
3385: where xaa.program_code = 'LNS_ADJUSTMENT_DEBIT' -- Bug#8231149
3386: and xpa.program_code = xaa.program_code
3387: and xaa.program_code = xad.program_code
3388: and xad.assignment_code = xaa.assignment_code