DBA Data[Home] [Help]

APPS.PA_IND_RATE_SCH_REVISIONS_PKG dependencies on PA_IND_COST_MULTIPLIERS

Line 787: FROM pa_ind_cost_multipliers

783: SELECT 1 INTO dummy
784: FROM sys.dual
785: WHERE EXISTS
786: (SELECT 1
787: FROM pa_ind_cost_multipliers
788: WHERE ind_rate_sch_revision_id = x_ind_rate_sch_revision_id);
789:
790: exception
791: when OTHERS then

Line 798: to check if the multiplier has changed in pa_ind_cost_multipliers.This will form the

794: end check_multipliers;
795:
796: -----------------------------------------------------------------------------
797: /***2933915:Added parameter x_ready_to_compile and another select in check_ready_compile()
798: to check if the multiplier has changed in pa_ind_cost_multipliers.This will form the
799: additional criteria for deciding if a revision can be compiled or not ***/
800:
801: procedure check_ready_compile(x_ind_rate_sch_revision_id IN number,
802: x_ready_compile_flag IN OUT NOCOPY varchar2,

Line 824: from pa_ind_cost_multipliers

820: SELECT 'Y'
821: INTO x_ready_for_compile
822: FROM dual
823: WHERE exists (select 1
824: from pa_ind_cost_multipliers
825: WHERE ind_rate_sch_revision_id = x_ind_rate_sch_revision_id
826: AND nvl(ready_to_compile_flag,'N') in ('Y','X'));
827: exception
828: When NO_DATA_FOUND then /*2933915*/