DBA Data[Home] [Help]

APPS.PA_RETN_BILLING_PKG dependencies on PA_PROJECT_UTILS

Line 2018: AND PA_Project_Utils.Check_prj_stus_action_allowed(pr.Project_Status_Code, 'GENERATE_INV') = 'Y'

2014: AND NVL(di.retention_invoice_flag,'N') = 'Y')
2015: AND EXISTS( SELECT NULL
2016: FROM pa_proj_retn_rules rt
2017: WHERE rt.project_id = pr.project_id)
2018: AND PA_Project_Utils.Check_prj_stus_action_allowed(pr.Project_Status_Code, 'GENERATE_INV') = 'Y'
2019: AND pr.project_type = t.project_type
2020: AND t.Project_type_class_code = 'CONTRACT'
2021: AND pr.segment1 between p_start_proj_number and p_end_proj_number
2022: ORDER BY pr.segment1;