APPS.PQP_USTIAA_PKG dependencies on PER_ASSIGNMENTS_F

Line 57: from per_assignments_f asg,

53: END IF;
54:
55:
56: sqlstr := 'select distinct asg.person_id
57: from per_assignments_f asg,
58: pay_assignment_actions act_run,
59: pay_payroll_actions ppa_run,
60: pay_payroll_actions ppa_gen
61: where ppa_gen.payroll_action_id = :payroll_action_id

Line 114: FROM per_assignments_f asg,

110: ppa_run.action_type ,
111: act_run.assignment_action_id,
112: asg.assignment_id ,
113: act_run.tax_unit_id
114: FROM per_assignments_f asg,
115: pay_payroll_actions ppa_run,
116: pay_assignment_actions act_run,
117: pay_payroll_actions ppa_gen
118: WHERE

Line 329: FROM per_assignments_f asg,

325: endperson NUMBER ) IS
326: SELECT
327: max(act_run.assignment_action_id),
328: asg.assignment_id
329: FROM per_assignments_f asg,
330: pay_payroll_actions ppa_run,
331: pay_assignment_actions act_run,
332: pay_payroll_actions ppa_gen
333: WHERE

Line 506: per_assignments_f pasg

502: CURSOR csr_asg_plan_no IS
503: SELECT paei.aei_information2,
504: pasg.payroll_id
505: FROM per_assignment_extra_info paei ,
506: per_assignments_f pasg
507: WHERE pasg.assignment_id = p_asg_id
508: AND pasg.assignment_id = paei.assignment_id(+)
509: AND paei.information_type(+) = 'PQP_US_TIAA_CREF_CODES'
510: AND p_date BETWEEN pasg.effective_start_date