APPS.PA_PJC_CWK_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45

                        G_PoLineIdTab.Delete;

Line: 50

                Select Po_Line_Id
                Into   L_Po_Line_Id
                From   Po_Distributions_All
                Where  Po_Distribution_id = P_Po_Distribution_Id;

Line: 98

                        G_IsRbLineTab.Delete;

Line: 160

                        G_ExCwkRbTCOrgIdTab.Delete;

Line: 165

                Select 'Y'
                Into   L_Exists
                From   Dual
                Where  Exists (Select 1
                               From Pa_Projects_All P,
                                    Po_Distributions_All Po
                               Where nvl(P.Org_Id, -99) = nvl(P_Org_Id, -99)
                                 And P.Project_Id = Po.Project_Id
                                 And PA_PJC_CWK_UTILS.is_rate_based_line (
                                        Po.Po_Line_Id,
                                        Po.Po_Distribution_Id) = 'Y'
                              );

Line: 231

                        G_CwkTCXfaceAllowedTab.Delete;

Line: 236

                Select I.Xface_Cwk_Timecards_Flag
                Into   L_Allowed
                From   Pa_Projects_All P,
                       Pa_Implementations_All I
                Where  P.Project_Id = P_Project_Id
                AND    p.org_id = i.org_id; -- bug 5365269