DBA Data[Home] [Help]

APPS.PA_FP_GEN_AMOUNT_UTILS dependencies on PA_BUDGET_LINES

Line 733: PA_BUDGET_LINES.txn_currency_code%TYPE,

729: PA_TASKS.TASK_ID%TYPE,
730: P_RESOURCE_LIST_MEMBER_ID IN
731: PA_RESOURCE_ASSIGNMENTS.resource_list_member_id%TYPE,
732: P_TXN_CURRENCY_CODE IN
733: PA_BUDGET_LINES.txn_currency_code%TYPE,
734: X_RES_FORMAT_ID OUT NOCOPY
735: PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE,
736: X_RESOURCE_ASN_REC OUT NOCOPY RESOURCE_ASN_REC,
737: X_PA_TASKS_REC OUT NOCOPY PA_TASKS_REC,

Line 2001: FROM pa_budget_lines

1997: SELECT 1 INTO l_bl_rejection_code_count
1998: FROM DUAL
1999: WHERE EXISTS
2000: ( SELECT null
2001: FROM pa_budget_lines
2002: WHERE budget_version_id = l_source_wp_ver_id
2003: AND ( cost_rejection_code IS NOT NULL
2004: OR revenue_rejection_code IS NOT NULL
2005: OR burden_rejection_code IS NOT NULL

Line 2055: FROM pa_budget_lines

2051: SELECT 1 INTO l_bl_rejection_code_count
2052: FROM DUAL
2053: WHERE EXISTS
2054: ( SELECT null
2055: FROM pa_budget_lines
2056: WHERE budget_version_id = l_source_fp_ver_id
2057: AND ( cost_rejection_code IS NOT NULL
2058: OR revenue_rejection_code IS NOT NULL
2059: OR burden_rejection_code IS NOT NULL