DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_ASGMT_APPRVL dependencies on PA_PROJECT_ASSIGNMENTS

Line 13: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE)

9: -- assignment end date, bill rates, transfer price rate override, transfer proce currency override,
10: -- transfer price basis override, transfer price applied % override
11: --
12: FUNCTION Is_Asgmt_Appr_Items_Changed
13: ( p_assignment_id IN pa_project_assignments.assignment_id%TYPE)
14: RETURN VARCHAR2
15: IS
16:
17: --Row(s) returned if No changes made

Line 20: FROM pa_project_assignments ppa,

16:
17: --Row(s) returned if No changes made
18: CURSOR items_not_changed IS
19: SELECT 'N'
20: FROM pa_project_assignments ppa,
21: pa_assignments_history pah,
22: pa_work_types_b wtv1,
23: pa_work_types_b wtv2
24: WHERE ppa.assignment_id = p_assignment_id