DBA Data[Home] [Help]

APPS.PA_RETN_BILLING_PKG dependencies on PA_PROJ_RETN_RULES

Line 2016: FROM pa_proj_retn_rules rt

2012: WHERE di.request_id = p_request_id
2013: AND di.project_id = pr.project_id
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'