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 114: FROM per_assignments_f asg,

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