APPS.PA_OTC_API dependencies on PA_EXP_OVRRDE_APPROVER_V

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

5898: -- this case it is not necessary to validate the overriding
5899: -- approver bcoz the LOV displays only valid approvers.
5900: -- However if the overriding approver_id is null and
5901: -- overriding approver_name is provided, then the approver
5902: -- name is validated against pa_exp_ovrrde_approver_v view.
5903: --
5904: -- Parameters :
5905: -- IN
5906: -- P_Approver_Id - Per_People_F.Person_Id%TYPE

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

5926: If P_Approver_Id is Not Null Then
5927:
5928: /*
5929: * Performance related change:
5930: * distinct clause added in this query so that the view Pa_Exp_Ovrrde_Approver_V
5931: * gets merged.
5932: */
5933: G_Stage := 'Get Overriding Approver Id.';
5934: Select

Line 5940: Pa_Exp_Ovrrde_Approver_V

5936: Person_Id
5937: Into
5938: X_Approver_Id
5939: From
5940: Pa_Exp_Ovrrde_Approver_V
5941: Where
5942: Person_Id = P_Approver_Id;
5943:
5944: Else -- P_Approver_Id is Null.