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 2727: FROM PA_PROJECT_FUNDINGS f

2723:
2724: CURSOR c1
2725: IS
2726: SELECT f.funding_category
2727: FROM PA_PROJECT_FUNDINGS f
2728: WHERE f.pm_funding_reference = p_pm_funding_reference;
2729:
2730: l_fund_rec1 c1%ROWTYPE;
2731: l_funding_category VARCHAR2(30);

Line 3093: FROM PA_PROJECT_FUNDINGS f

3089:
3090: CURSOR c1
3091: IS
3092: SELECT f.funding_category
3093: FROM PA_PROJECT_FUNDINGS f
3094: WHERE f.pm_funding_reference = p_pm_funding_reference
3095: AND f.funding_category = 'REVALUATION';/* Added this condition for 3360593*/
3096:
3097: l_fund_rec1 c1%ROWTYPE;

Line 3425: FROM pa_project_fundings

3421:
3422: IF (p_funding_category = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3423: SELECT funding_category
3424: INTO l_funding_category
3425: FROM pa_project_fundings
3426: WHERE PROJECT_FUNDING_ID = l_out_funding_id;
3427: END IF;
3428:
3429:

Line 5904: FROM pa_project_fundings pf, pa_tasks t

5900: to_char(NULL),
5901: to_char(NULL),
5902: to_char(NULL)
5903: /* Bug 2866699 Added due to Fin plan impact ends here */
5904: FROM pa_project_fundings pf, pa_tasks t
5905: WHERE pf.project_id = p_pa_project_id
5906: AND pf.task_id = t.task_id(+)
5907: AND pf.budget_type_code in ('BASELINE', 'DRAFT')
5908: group by nvl(pf.task_id,0),