DBA Data[Home] [Help]

APPS.PAY_CA_RL1_REG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 413: from hr_assignment_set_amendments hasa,

409: and ppa.action_status = 'C'
410: and ppa.payroll_action_id = paa.payroll_action_id
411: and to_number(paa.serial_number) between stperson and endperson
412: and exists (select 1
413: from hr_assignment_set_amendments hasa,
414: per_assignments_f paf
415: where hasa.assignment_set_id = l_asg_set_id
416: and upper(hasa.include_or_exclude) = 'I'
417: and hasa.assignment_id = paf.assignment_id

Line 445: from hr_assignment_set_amendments hasa,

441: and ppr.payroll_action_id = pactid
442: and ppr.chunk_number = chunk
443: and ppr.person_id = to_number(paa.serial_number)
444: and exists (select 1
445: from hr_assignment_set_amendments hasa,
446: per_assignments_f paf
447: where hasa.assignment_set_id = l_asg_set_id
448: and upper(hasa.include_or_exclude) = 'I'
449: and hasa.assignment_id = paf.assignment_id