APPS.PA_BILLING_CORE dependencies on PA_PROJECTS_ALL

Line 46: from pa_projects_all

42:
43:
44: cursor cost is
45: select 1
46: from pa_projects_all
47: where project_id = x_project_id
48: and substr(distribution_rule, 1, 5) = 'COST/';
49:
50: /* Commented for bug 2744993

Line 797: update pa_projects_all

793: WHERE evt.project_id = x_project_id
794: AND evt.project_funding_id IS NOT NULL;
795:
796: -- update project level funding flag
797: update pa_projects_all
798: set project_level_funding_flag = decode(x_funding_level,'P','Y','N'),
799: last_update_date = SYSDATE,
800: last_updated_by = x_created_by,
801: last_update_login = x_last_update_login

Line 976: FROM PA_Projects_All

972: -- implemented with Top Task invoice method flag then
973: -- the default fundling level should be Task level funding
974: BEGIN
975: Select 'T' INTO x_funding_level
976: FROM PA_Projects_All
977: Where Project_ID = X_Project_ID
978: AND (ENABLE_TOP_TASK_CUSTOMER_FLAG = 'Y' OR
979: ENABLE_TOP_TASK_INV_MTH_FLAG = 'Y' );
980: Exception When NO_Data_Found then

Line 1183: FROM pa_agreements_all a, pa_projects_all p

1179: nvl(x_owning_organization_id,a.owning_organization_id),
1180: a.invoice_limit_flag,
1181: mo_global.get_current_org_id
1182: /* MCB2 columns end */
1183: FROM pa_agreements_all a, pa_projects_all p
1184: WHERE p.project_id = x_new_project_id
1185: /* Bug 727421 Performance Issue
1186: AND exists
1187: (select null

Line 1825: FROM PA_Projects_All

1821: -- Get the funding level value
1822: BEGIN
1823: Select Project_Level_Funding_Flag
1824: INTO l_Funding_Level_Flag
1825: FROM PA_Projects_All
1826: Where Project_ID = P_Project_ID;
1827: Exception When NO_Data_Found then
1828: l_Funding_Level_Flag := 'P';
1829: END;

Line 1885: FROM PA_Projects_All

1881: BEGIN
1882:
1883: Select Project_Level_Funding_Flag
1884: INTO l_Funding_Level_Flag
1885: FROM PA_Projects_All
1886: Where Project_ID = P_Project_ID;
1887:
1888: Exception When NO_Data_Found then
1889: l_Funding_Level_Flag := 'P';