eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_AGREEMENT_PUB dependencies on PA_PROJECT_FUNDINGS

Line 978: FROM pa_project_fundings f

974: -- Local Cursors
975: CURSOR l_funding_id_csr(p_agreement_id NUMBER)
976: IS
977: SELECT project_funding_id,pm_funding_reference,agreement_id
978: FROM pa_project_fundings f
979: WHERE f.agreement_id = p_agreement_id;
980: -- Local variables
981: l_msg_count NUMBER ;
982: l_msg_data VARCHAR2(2000);

Line 2019: l_project_rate_type PA_PROJECT_FUNDINGS.PROJECT_RATE_TYPE%type;

2015: l_resize_flag VARCHAR2(1); /* Added for bug 2902096 */
2016: l_funding_category VARCHAR2(30); /* Added for bug 2838872 */
2017:
2018: /*Start of bug 5554070*/
2019: l_project_rate_type PA_PROJECT_FUNDINGS.PROJECT_RATE_TYPE%type;
2020: l_projfunc_rate_type PA_PROJECT_FUNDINGS.PROJFUNC_RATE_TYPE%type;
2021: l_projfunc_rate_date PA_PROJECT_FUNDINGS.PROJFUNC_RATE_DATE%type;
2022: l_project_rate_date PA_PROJECT_FUNDINGS.PROJECT_RATE_DATE%type;
2023: /*End of bug 5554070*/

Line 2020: l_projfunc_rate_type PA_PROJECT_FUNDINGS.PROJFUNC_RATE_TYPE%type;

2016: l_funding_category VARCHAR2(30); /* Added for bug 2838872 */
2017:
2018: /*Start of bug 5554070*/
2019: l_project_rate_type PA_PROJECT_FUNDINGS.PROJECT_RATE_TYPE%type;
2020: l_projfunc_rate_type PA_PROJECT_FUNDINGS.PROJFUNC_RATE_TYPE%type;
2021: l_projfunc_rate_date PA_PROJECT_FUNDINGS.PROJFUNC_RATE_DATE%type;
2022: l_project_rate_date PA_PROJECT_FUNDINGS.PROJECT_RATE_DATE%type;
2023: /*End of bug 5554070*/
2024:

Line 2021: l_projfunc_rate_date PA_PROJECT_FUNDINGS.PROJFUNC_RATE_DATE%type;

2017:
2018: /*Start of bug 5554070*/
2019: l_project_rate_type PA_PROJECT_FUNDINGS.PROJECT_RATE_TYPE%type;
2020: l_projfunc_rate_type PA_PROJECT_FUNDINGS.PROJFUNC_RATE_TYPE%type;
2021: l_projfunc_rate_date PA_PROJECT_FUNDINGS.PROJFUNC_RATE_DATE%type;
2022: l_project_rate_date PA_PROJECT_FUNDINGS.PROJECT_RATE_DATE%type;
2023: /*End of bug 5554070*/
2024:
2025: l_err_code number;

Line 2022: l_project_rate_date PA_PROJECT_FUNDINGS.PROJECT_RATE_DATE%type;

2018: /*Start of bug 5554070*/
2019: l_project_rate_type PA_PROJECT_FUNDINGS.PROJECT_RATE_TYPE%type;
2020: l_projfunc_rate_type PA_PROJECT_FUNDINGS.PROJFUNC_RATE_TYPE%type;
2021: l_projfunc_rate_date PA_PROJECT_FUNDINGS.PROJFUNC_RATE_DATE%type;
2022: l_project_rate_date PA_PROJECT_FUNDINGS.PROJECT_RATE_DATE%type;
2023: /*End of bug 5554070*/
2024:
2025: l_err_code number;
2026: l_err_msg VARCHAR2(50);

Line 2790: FROM PA_PROJECT_FUNDINGS f

2786:
2787: CURSOR c1
2788: IS
2789: SELECT f.funding_category
2790: FROM PA_PROJECT_FUNDINGS f
2791: WHERE f.pm_funding_reference = p_pm_funding_reference;
2792:
2793: l_fund_rec1 c1%ROWTYPE;
2794: l_funding_category VARCHAR2(30);

Line 3156: FROM PA_PROJECT_FUNDINGS f

3152:
3153: CURSOR c1
3154: IS
3155: SELECT f.funding_category
3156: FROM PA_PROJECT_FUNDINGS f
3157: WHERE f.pm_funding_reference = p_pm_funding_reference
3158: AND f.funding_category = 'REVALUATION';/* Added this condition for 3360593*/
3159:
3160: l_fund_rec1 c1%ROWTYPE;

Line 3185: FROM pa_summary_project_fundings f,pa_project_fundings p

3181: IS
3182: SELECT f.projfunc_accrued_amount,f.projfunc_billed_amount,
3183: (f.projfunc_baselined_amount+f.projfunc_unbaselined_amount) total_funding,
3184: p.projfunc_allocated_amount
3185: FROM pa_summary_project_fundings f,pa_project_fundings p
3186: WHERE f.agreement_id = p_agreement_id
3187: AND p.project_funding_id = p_funding_id; commented for bug 14696063 */
3188:
3189: /* Bug 13434695 */

Line 3195: FROM pa_summary_project_fundings f,pa_project_fundings p

3191: IS
3192: SELECT f.total_accrued_amount,f.total_billed_amount,
3193: (f.total_baselined_amount+f.total_unbaselined_amount) total_funding,
3194: p.allocated_amount
3195: FROM pa_summary_project_fundings f,pa_project_fundings p
3196: where F.AGREEMENT_ID =p_agreement_id
3197: and F.AGREEMENT_ID=P.AGREEMENT_ID
3198: and P.PROJECT_ID=F.PROJECT_ID
3199: and NVL(f.TASK_ID,-1)=NVL(p.TASK_ID,-1)

Line 3559: FROM pa_project_fundings

3555:
3556: IF (p_funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3557: SELECT funding_category
3558: INTO l_funding_category
3559: FROM pa_project_fundings
3560: WHERE PROJECT_FUNDING_ID = l_out_funding_id;
3561: END IF;
3562:
3563:

Line 6042: FROM pa_project_fundings pf, pa_tasks t

6038: to_char(NULL),
6039: to_char(NULL),
6040: to_char(NULL)
6041: /* Bug 2866699 Added due to Fin plan impact ends here */
6042: FROM pa_project_fundings pf, pa_tasks t
6043: WHERE pf.project_id = p_pa_project_id
6044: AND pf.task_id = t.task_id(+)
6045: AND pf.budget_type_code in ('BASELINE', 'DRAFT')
6046: group by nvl(pf.task_id,0),