DBA Data[Home] [Help]

APPS.PA_CAP_INT_PVT dependencies on PA_CINT_RATE_MULTIPLIERS

Line 673: FROM pa_cint_rate_multipliers rate

669: INTO l_rate_falg
670: FROM DUAL
671: WHERE EXISTS (
672: SELECT null
673: FROM pa_cint_rate_multipliers rate
674: WHERE rate.ind_rate_sch_id = p_sch_id
675: AND rate.ind_rate_sch_revision_id = p_sch_rev_id
676: AND rate.rate_name = p_rate_name
677: );

Line 924: FROM pa_cint_rate_multipliers

920: ln_organization_id hr_all_organization_units.organization_id%TYPE;
921:
922: CURSOR cur_mult IS
923: SELECT multiplier
924: FROM pa_cint_rate_multipliers
925: WHERE rate_name = p_rate_name
926: AND organization_id = ln_organization_id
927: AND ind_rate_sch_revision_id = p_sched_version_id;
928:

Line 1385: /* Bug fix:3208751 ,pa_cint_rate_multipliers pccm

1381: (SELECT 'X'
1382: FROM pa_projects pp
1383: ,pa_ind_rate_schedules_all_bg pirs
1384: ,pa_ind_rate_sch_revisions pirsv
1385: /* Bug fix:3208751 ,pa_cint_rate_multipliers pccm
1386: ,pa_ind_cost_multipliers pccm
1387: WHERE pp.cint_rate_sch_id = pirs.ind_rate_sch_id
1388: AND pirs.ind_rate_sch_usage = 'CAPITALIZED_INTEREST'
1389: AND pirs.ind_rate_sch_id = pirsv.ind_rate_sch_id