APPS.PA_RETENTION_PKG dependencies on PA_PROJECTS_ALL

Line 83: pa_projects_all pr

79: NVL(fmtdet.right_justify_flag,'N') right_justify_flag
80: FROM pa_invoice_group_columns grp,
81: pa_invoice_formats fmt,
82: pa_invoice_format_details fmtdet,
83: pa_projects_all pr
84: WHERE pr.retention_invoice_format_id = fmt.invoice_format_id
85: AND fmt.invoice_format_id = fmtdet.invoice_format_id
86: AND grp.invoice_group_column_id = fmtdet.invoice_group_column_id
87: and pr.project_id =p_project_id

Line 696: FROM pa_projects_all pr

692: decode(pr.invproc_currency_type,'PROJECT_CURRENCY', pr.project_currency_code,
693: 'PROJFUNC_CURRENCY',pr.projfunc_currency_code,
694: 'FUNDING_CURRENCY', FundingCurrency) Invproc_currency, pr.invproc_currency_type
695: INTO ProjectCurrency, ProjFuncCUrrency, InvProcCurrency, InvProcCurrType
696: FROM pa_projects_all pr
697: WHERE pr.project_id = p_project_id;
698: --till here for Bug3604143
699:
700: OPEN cur_invoice;

Line 788: FROM pa_projects_all pr

784: decode(pr.invproc_currency_type,'PROJECT_CURRENCY', pr.project_currency_code,
785: 'PROJFUNC_CURRENCY',pr.projfunc_currency_code,
786: 'FUNDING_CURRENCY', FundingCurrency) Invproc_currency
787: INTO ProjectCurrency, ProjFuncCUrrency, InvProcCurrency
788: FROM pa_projects_all pr
789: WHERE pr.project_id = p_project_id;
790: */
791:
792: IF g1_debug_mode = 'Y' THEN

Line 1568: pa_projects_all pr,

1564: */
1565: hz_site.site_use_id bill_site_use_id,
1566: hz_site1.site_use_id ship_site_use_id
1567: FROM pa_project_customers pc,
1568: pa_projects_all pr,
1569: pa_implementations_all imp,
1570: /* TCA changes
1571: ra_site_uses ras,
1572: ra_site_uses ras1

Line 1617: pa_projects_all pr

1613: agr.agreement_id agreement_id,
1614: NVL(pr.inv_by_bill_trans_curr_flag,'N') inv_by_bill_trans_curr_flag,
1615: di.inv_currency_code invoice_currency_code
1616: FROM pa_draft_invoices_all di, pa_agreements_all agr,
1617: pa_projects_all pr
1618: WHERE NVL(di.canceled_flag,'N') ='N'
1619: AND NVL(di.cancel_credit_memo_flag ,'N') ='N'
1620: AND NVL(di.draft_invoice_num_credited,0) = 0
1621: AND di.request_id = p_request_id

Line 3741: From PA_Projects_All

3737: l_Inv_Method_Top_Task_Flag VARCHAR2(1);
3738: BEGIN
3739: Select ENABLE_TOP_TASK_CUSTOMER_FLAG, ENABLE_TOP_TASK_INV_MTH_FLAG
3740: Into l_Cust_Top_Task_Flag, l_Inv_Method_Top_Task_Flag
3741: From PA_Projects_All
3742: Where Project_ID = P_Project_ID;
3743:
3744: -- Dbms_Output.Put_Line('Flag value 1 : '|| l_Cust_Top_Task_Flag);
3745: -- Dbms_Output.Put_Line('Flag value 2 : '|| l_Inv_Method_Top_Task_Flag);