DBA Data[Home] [Help]

APPS.PAY_CA_RL2_REG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 311: from hr_assignment_set_amendments hasa,

307: and ppa.action_status = 'C'
308: and ppa.payroll_action_id = paa.payroll_action_id
309: and to_number(paa.serial_number) between stperson and endperson
310: and exists (select 1
311: from hr_assignment_set_amendments hasa,
312: per_assignments_f paf
313: where hasa.assignment_set_id = l_asg_set_id
314: and upper(hasa.include_or_exclude) = 'I'
315: and hasa.assignment_id = paf.assignment_id

Line 344: from hr_assignment_set_amendments hasa,

340: and ppr.payroll_action_id = pactid
341: and ppr.chunk_number = chunk
342: and ppr.person_id = to_number(paa.serial_number)
343: and exists (select 1
344: from hr_assignment_set_amendments hasa,
345: per_assignments_f paf
346: where hasa.assignment_set_id = l_asg_set_id
347: and upper(hasa.include_or_exclude) = 'I'
348: and hasa.assignment_id = paf.assignment_id