DBA Data[Home] [Help]

APPS.CST_ACCRUAL_REC_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 99: from financials_system_params_all fsp,

95: from cst_accrual_accounts caa
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

Line 120: from financials_system_params_all fsp,

116: from cst_accrual_accounts caa
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

Line 146: from financials_system_params_all fsp,

142: from cst_accrual_accounts caa
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

Line 1395: from financials_system_params_all

1391: if(c_wo_rec.l_tot_bal > (l_wo_cr * l_ent_sum)) then
1392: --{
1393: select rate_var_gain_ccid
1394: into l_erv_id
1395: from financials_system_params_all
1396: where org_id = p_ou_id;
1397: --}
1398: else
1399: --{

Line 1402: from financials_system_params_all

1398: else
1399: --{
1400: select rate_var_loss_ccid
1401: into l_erv_id
1402: from financials_system_params_all
1403: where org_id = p_ou_id;
1404: --}
1405: end if; /* c_wo_rec.l_tot_bal > (l_wo_cr + l_ent_sum) */
1406: --}