APPS.PA_OTC_API dependencies on PA_EXP_OVRRDE_APPROVER_V

Line 6369: -- name is validated against pa_exp_ovrrde_approver_v view.

6365: -- this case it is not necessary to validate the overriding
6366: -- approver bcoz the LOV displays only valid approvers.
6367: -- However if the overriding approver_id is null and
6368: -- overriding approver_name is provided, then the approver
6369: -- name is validated against pa_exp_ovrrde_approver_v view.
6370: --
6371: -- Parameters :
6372: -- IN
6373: -- P_Approver_Id - Per_People_F.Person_Id%TYPE

Line 6397: * distinct clause added in this query so that the view Pa_Exp_Ovrrde_Approver_V

6393: If P_Approver_Id is Not Null Then
6394:
6395: /*
6396: * Performance related change:
6397: * distinct clause added in this query so that the view Pa_Exp_Ovrrde_Approver_V
6398: * gets merged.
6399: */
6400: G_Stage := 'Get Overriding Approver Id.';
6401: Select

Line 6407: Pa_Exp_Ovrrde_Approver_V

6403: Person_Id
6404: Into
6405: X_Approver_Id
6406: From
6407: Pa_Exp_Ovrrde_Approver_V
6408: Where
6409: Person_Id = P_Approver_Id;
6410:
6411: Else -- P_Approver_Id is Null.