APPS.PA_RETENTION_PKG dependencies on PA_PROJECTS_ALL

Line 101: pa_projects_all pr

97: NVL(fmtdet.right_justify_flag,'N') right_justify_flag
98: FROM pa_invoice_group_columns grp,
99: pa_invoice_formats fmt,
100: pa_invoice_format_details fmtdet,
101: pa_projects_all pr
102: WHERE pr.retention_invoice_format_id = fmt.invoice_format_id
103: AND fmt.invoice_format_id = fmtdet.invoice_format_id
104: AND grp.invoice_group_column_id = fmtdet.invoice_group_column_id
105: and pr.project_id =p_project_id

Line 714: FROM pa_projects_all pr

710: decode(pr.invproc_currency_type,'PROJECT_CURRENCY', pr.project_currency_code,
711: 'PROJFUNC_CURRENCY',pr.projfunc_currency_code,
712: 'FUNDING_CURRENCY', FundingCurrency) Invproc_currency, pr.invproc_currency_type
713: INTO ProjectCurrency, ProjFuncCUrrency, InvProcCurrency, InvProcCurrType
714: FROM pa_projects_all pr
715: WHERE pr.project_id = p_project_id;
716: --till here for Bug3604143
717:
718: OPEN cur_invoice;

Line 806: FROM pa_projects_all pr

802: decode(pr.invproc_currency_type,'PROJECT_CURRENCY', pr.project_currency_code,
803: 'PROJFUNC_CURRENCY',pr.projfunc_currency_code,
804: 'FUNDING_CURRENCY', FundingCurrency) Invproc_currency
805: INTO ProjectCurrency, ProjFuncCUrrency, InvProcCurrency
806: FROM pa_projects_all pr
807: WHERE pr.project_id = p_project_id;
808: */
809:
810: IF g1_debug_mode = 'Y' THEN

Line 1586: pa_projects_all pr,

1582: */
1583: hz_site.site_use_id bill_site_use_id,
1584: hz_site1.site_use_id ship_site_use_id
1585: FROM pa_project_customers pc,
1586: pa_projects_all pr,
1587: pa_implementations_all imp,
1588: /* TCA changes
1589: ra_site_uses ras,
1590: ra_site_uses ras1

Line 1635: pa_projects_all pr

1631: agr.agreement_id agreement_id,
1632: NVL(pr.inv_by_bill_trans_curr_flag,'N') inv_by_bill_trans_curr_flag,
1633: di.inv_currency_code invoice_currency_code
1634: FROM pa_draft_invoices_all di, pa_agreements_all agr,
1635: pa_projects_all pr
1636: WHERE NVL(di.canceled_flag,'N') ='N'
1637: AND NVL(di.cancel_credit_memo_flag ,'N') ='N'
1638: AND NVL(di.draft_invoice_num_credited,0) = 0
1639: AND di.request_id = p_request_id

Line 3778: From PA_Projects_All

3774: l_Inv_Method_Top_Task_Flag VARCHAR2(1);
3775: BEGIN
3776: Select ENABLE_TOP_TASK_CUSTOMER_FLAG, ENABLE_TOP_TASK_INV_MTH_FLAG
3777: Into l_Cust_Top_Task_Flag, l_Inv_Method_Top_Task_Flag
3778: From PA_Projects_All
3779: Where Project_ID = P_Project_ID;
3780:
3781: -- Dbms_Output.Put_Line('Flag value 1 : '|| l_Cust_Top_Task_Flag);
3782: -- Dbms_Output.Put_Line('Flag value 2 : '|| l_Inv_Method_Top_Task_Flag);