APPS.PAY_AU_SGC_PKG dependencies on PER_ASSIGNMENTS_F

Line 104: per_assignments_f assign,

100: Cursor assign_work_hrs (c_effective_date date,
101: c_assignment_id per_all_assignments_f.assignment_id%type)
102: is
103: select assign.normal_hours from
104: per_assignments_f assign,
105: hr_lookups hr3
106: where c_effective_date between assign.effective_start_date and
107: assign.effective_end_date and
108: assign.assignment_id = c_assignment_id and

Line 123: c_assignment_id per_assignments_f.assignment_id%TYPE,

119: /*Bug2920725 Corrected base tables to support security model*/
120:
121: CURSOR assign_work_hrs
122: (c_effective_date date,
123: c_assignment_id per_assignments_f.assignment_id%TYPE,
124: c_business_group_id per_all_assignments_f.business_group_id%TYPE,
125: c_registered_employer NUMBER -- 2610141
126: )
127: is

Line 134: per_assignments_f paa,

130: decode(hoi.org_information4,'W',hoi.org_information3,
131: null)
132: )),g_min_hrs_worked + 1)
133: from
134: per_assignments_f paa,
135: hr_soft_coding_keyflex hsck,
136: hr_organization_information hoi,
137: hr_organization_units hou
138: where