APPS.PA_FP_WEBADI_UTILS dependencies on PA_FP_WEBADI_XFACE_TMP

Line 1703: FROM PA_FP_WEBADI_XFACE_TMP a

1699: -- budget lines table with overlapping dates.
1700:
1701: CURSOR C_OVERLAPPING_CUR IS
1702: SELECT a.rowid
1703: FROM PA_FP_WEBADI_XFACE_TMP a
1704: WHERE a.budget_version_id = p_budget_version_id
1705: AND ( EXISTS (SELECT 'Y'
1706: FROM PA_FP_WEBADI_XFACE_TMP b
1707: WHERE a.rowid <> b.rowid

Line 1706: FROM PA_FP_WEBADI_XFACE_TMP b

1702: SELECT a.rowid
1703: FROM PA_FP_WEBADI_XFACE_TMP a
1704: WHERE a.budget_version_id = p_budget_version_id
1705: AND ( EXISTS (SELECT 'Y'
1706: FROM PA_FP_WEBADI_XFACE_TMP b
1707: WHERE a.rowid <> b.rowid
1708: AND b.budget_version_id = p_budget_version_id
1709: AND b.resource_assignment_id = a.resource_assignment_id
1710: AND b.txn_currency_code = a.txn_currency_code

Line 1762: UPDATE PA_FP_WEBADI_XFACE_TMP tmp

1758: FETCH C_OVERLAPPING_CUR INTO
1759: l_rowid ;
1760: IF C_OVERLAPPING_CUR%FOUND THEN
1761: x_rec_failed_validation := 'Y' ;
1762: UPDATE PA_FP_WEBADI_XFACE_TMP tmp
1763: SET val_error_code = 'PA_FP_WEBADI_OVERLAPPING_DATE'
1764: ,val_error_flag = 'Y'
1765: WHERE rowid = l_rowid ;
1766: END IF ;