DBA Data[Home] [Help]

APPS.PA_CALC_OVERTIME dependencies on PER_ASSIGNMENTS_F

Line 61: FROM per_assignments_f a,

57: Job_ID number;
58: BEGIN
59: SELECT job_id
60: INTO Job_Id
61: FROM per_assignments_f a,
62: pa_expenditures ex
63: WHERE ex.expenditure_id = X_expenditure_id
64: AND a.person_id = ex.incurred_by_person_id
65: AND (a.assignment_type = 'E' OR a.assignment_type = 'C')

Line 84: FROM per_assignments_f a,

80: * next weekending date - to get the job_id.
81: */
82: SELECT job_id
83: INTO Job_Id
84: FROM per_assignments_f a,
85: pa_expenditures ex
86: WHERE ex.expenditure_id = X_expenditure_id
87: AND a.person_id = ex.incurred_by_person_id
88: AND (a.assignment_type = 'E' OR a.assignment_type = 'C')