APPS.PAY_NZ_QES_PKG dependencies on PER_ASSIGNMENTS_F

Line 37: per_assignments_f paa /*Bug 2920728*/

33: from hr_soft_coding_keyflex hsck,
34: pay_payrolls_f pay, /*Bug 2920728*/
35: per_time_periods ptp,
36: per_people_f pap, /*Bug 2920728*/
37: per_assignments_f paa /*Bug 2920728*/
38: where hsck.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
39: and hsck.segment1 = to_char(c_organization_id)
40: and pay.payroll_id = c_payroll_id
41: and ptp.time_period_id = c_time_period_id

Line 114: per_assignments_f paa /*Bug 2920728*/

110: from hr_soft_coding_keyflex hsck,
111: pay_payrolls_f pay, /*Bug 2929728*/
112: per_time_periods ptp,
113: per_people_f pap, /*Bug 2920728*/
114: per_assignments_f paa /*Bug 2920728*/
115: where hsck.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
116: and hsck.segment1 = to_char(c_organization_id)
117: and pay.payroll_id = c_payroll_id
118: and ptp.time_period_id = c_time_period_id

Line 227: per_assignments_f paa /*Bug 2920728*/

223: from hr_soft_coding_keyflex hsck,
224: pay_payrolls_f pay, /*Bug 2920728*/
225: per_time_periods ptp,
226: per_people_f pap, /*Bug 2920728*/
227: per_assignments_f paa /*Bug 2920728*/
228: where hsck.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
229: and hsck.segment1 = to_char(c_organization_id)
230: and pay.payroll_id = c_payroll_id
231: and ptp.time_period_id = c_time_period_id

Line 357: per_assignments_f paa /*Bug 2920728*/

353: select paa.normal_hours,
354: paa.frequency frequency_code, -- to pass to convert_hours
355: hl.meaning frequency -- to compare to payroll_frequency
356: from hr_lookups hl,
357: per_assignments_f paa /*Bug 2920728*/
358: where hl.application_id = 800
359: and paa.assignment_id = c_assignment_id
360: and paa.frequency = hl.lookup_code
361: and hl.lookup_type = 'FREQUENCY';