APPS.PAY_NEGBAL_PKG dependencies on PER_ASSIGNMENTS_F

Line 73: FROM per_assignments_f paf,

69: INTO l_resides_true
70: FROM dual
71: WHERE EXISTS (
72: SELECT '1'
73: FROM per_assignments_f paf,
74: per_addresses pad
75: WHERE paf.assignment_id = p_assignment_id AND
76: paf.person_id = pad.person_id AND
77: pad.date_from <= p_period_end AND

Line 152: FROM per_assignments_f ASG,

148:
149:
150: /* Negative Balance Code */
151: sqlstr := 'SELECT distinct ASG.person_id
152: FROM per_assignments_f ASG,
153: hr_organization_units HOU,
154: pay_payrolls_f PPY,
155: pay_state_rules SR,
156: hr_organization_information HOI,

Line 225: per_assignments_f asg,

221: FROM hr_organization_information hoi,
222: pay_payroll_actions ppa,
223: pay_assignment_actions paa,
224: pay_state_rules sr,
225: per_assignments_f asg,
226: pay_payroll_actions ppa_arch
227: WHERE ppa_arch.payroll_action_id = pactid
228: AND asg.person_id between stperson and endperson
229: AND asg.business_group_id + 0 = ppa_arch.business_group_id

Line 239: per_assignments_f paf1

235: in (select max(paa1.action_sequence),paf1.person_id, paa1.tax_unit_id
236: from pay_action_classifications pac,
237: pay_payroll_actions ppa1,
238: pay_assignment_actions paa1,
239: per_assignments_f paf1
240: where paf1.person_id = asg.person_id
241: AND paf1.business_group_id + 0 = ppa_arch.business_group_id
242: AND paf1.assignment_type = 'E'
243: AND paf1.effective_start_date <= l_period_end