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_SUMMARY_PROJECT_FUNDINGS

Line 801: FROM pa_summary_project_fundings

797: THEN
798: BEGIN
799: l_valid_currency:='Y';
800: SELECT distinct funding_currency_code INTO l_old_fund_curr_code
801: FROM pa_summary_project_fundings
802: WHERE project_id=l_funding_in_rec.project_id
803: and not (total_baselined_amount = 0
804: and total_unbaselined_amount = 0); /* Added for bug 6510026 */
805:

Line 2046: FROM pa_summary_project_fundings f

2042: /*CURSOR l_amounts_csr(p_agreement_id NUMBER)
2043: IS
2044: SELECT f.projfunc_accrued_amount,f.projfunc_billed_amount,
2045: (f.projfunc_baselined_amount+f.projfunc_unbaselined_amount) total_funding
2046: FROM pa_summary_project_fundings f
2047: WHERE f.agreement_id = p_agreement_id;
2048: Rewritten for bug 14696063 */
2049: CURSOR l_amounts_csr(p_agreement_id NUMBER,p_project_id NUMBER, p_task_id NUMBER)
2050: IS

Line 2053: FROM pa_summary_project_fundings f

2049: CURSOR l_amounts_csr(p_agreement_id NUMBER,p_project_id NUMBER, p_task_id NUMBER)
2050: IS
2051: SELECT f.total_accrued_amount,f.total_billed_amount,
2052: (f.total_baselined_amount+f.total_unbaselined_amount) total_funding
2053: FROM pa_summary_project_fundings f
2054: WHERE f.agreement_id = p_agreement_id
2055: AND f.project_id = p_project_id
2056: AND NVL(f.task_id,-1)=NVL(p_task_id,-1);/*Re written for bug 14696063*/
2057: /* Bug 13434695 */

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)