DBA Data[Home] [Help]

APPS.CST_ACCRUAL_REC_PVT dependencies on GL_SETS_OF_BOOKS

Line 100: gl_sets_of_books gsb,

96: where caa.accrual_account_id = paat.accrual_account_id
97: and caa.operating_unit_id = p_ou_id)
98: and exists ( select 1
99: from financials_system_params_all fsp,
100: gl_sets_of_books gsb,
101: gl_code_combinations gcc
102: where gsb.set_of_books_id = fsp.set_of_books_id
103: and fsp.org_id = p_ou_id
104: and gcc.code_combination_id = paat.accrual_account_id

Line 121: gl_sets_of_books gsb,

117: where caa.accrual_account_id = psp.accrued_code_combination_id
118: and caa.operating_unit_id = p_ou_id)
119: and exists ( select 1
120: from financials_system_params_all fsp,
121: gl_sets_of_books gsb,
122: gl_code_combinations gcc
123: where gsb.set_of_books_id = fsp.set_of_books_id
124: and fsp.org_id = p_ou_id
125: and gcc.code_combination_id = psp.accrued_code_combination_id

Line 147: gl_sets_of_books gsb,

143: where caa.accrual_account_id = mp.ap_accrual_account
144: and caa.operating_unit_id = p_ou_id)
145: and exists ( select 1
146: from financials_system_params_all fsp,
147: gl_sets_of_books gsb,
148: gl_code_combinations gcc
149: where gsb.set_of_books_id = fsp.set_of_books_id
150: and fsp.org_id = p_ou_id
151: and gcc.code_combination_id = mp.ap_accrual_account

Line 1351: gl_sets_of_books gsb

1347: into l_wo_cr
1348: from po_distributions_all pod,
1349: po_line_locations_all poll,
1350: po_headers_all poh,
1351: gl_sets_of_books gsb
1352: where pod.po_distribution_id = c_wo_rec.po_distribution_id
1353: and pod.org_id = p_ou_id
1354: and poh.po_header_id = pod.po_header_id
1355: and poll.line_location_id = pod.line_location_id