APPS.PQP_EXPPREPROC_PKG dependencies on PER_ASSIGNMENTS_F

Line 49: from per_assignments_f asg,

45: l_consolidation_set_id,
46: l_temp_date );
47:
48: sqlstr := 'select distinct asg.person_id
49: from per_assignments_f asg,
50: pay_assignment_actions act_run, /* run and quickpay assignment actions */
51: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
52: pay_payroll_actions ppa_gen /* PYUGEN information */
53: where ppa_gen.payroll_action_id = :payroll_action_id

Line 116: FROM per_assignments_f asg,

112: ) IS
113: SELECT
114: MAX(act_run.assignment_action_id),
115: asg.assignment_id
116: FROM per_assignments_f asg,
117: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
118: pay_assignment_actions act_run, /* run and quickpay assignment actions */
119: pay_payroll_actions ppa_gen, /* PYUGEN information */
120: per_time_periods ptp

Line 179: FROM per_assignments_f asg,

175: ) IS
176: SELECT /*+ LEADING(ppa_gen ppa_run ptp asg act_run) */
177: MAX(act_run.assignment_action_id),
178: asg.assignment_id
179: FROM per_assignments_f asg,
180: pay_payroll_actions ppa_run, /* run and quickpay payroll actions */
181: pay_assignment_actions act_run, /* run and quickpay assignment actions */
182: pay_payroll_actions ppa_gen, /* PYUGEN information */
183: per_time_periods ptp