eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ZA_TYE_ARCHIVE_PKG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 647: from hr_assignment_set_amendments hasa1

643: where has1.assignment_set_id = '||l_asg_set_id||'
644: and has1.business_group_id = paf.business_group_id
645: and nvl(has1.payroll_id,paf.payroll_id) = paf.payroll_id
646: and (not exists (select 1
647: from hr_assignment_set_amendments hasa1
648: where hasa1.assignment_set_id = has1.assignment_set_id)
649: or exists (select 1
650: from hr_assignment_set_amendments hasa2
651: where hasa2.assignment_set_id = has1.assignment_set_id

Line 650: from hr_assignment_set_amendments hasa2

646: and (not exists (select 1
647: from hr_assignment_set_amendments hasa1
648: where hasa1.assignment_set_id = has1.assignment_set_id)
649: or exists (select 1
650: from hr_assignment_set_amendments hasa2
651: where hasa2.assignment_set_id = has1.assignment_set_id
652: and hasa2.assignment_id = paf.assignment_id
653: and nvl(hasa2.include_or_exclude,''I'') = ''I'')
654: or (not exists (select 1

Line 655: from hr_assignment_set_amendments hasa3

651: where hasa2.assignment_set_id = has1.assignment_set_id
652: and hasa2.assignment_id = paf.assignment_id
653: and nvl(hasa2.include_or_exclude,''I'') = ''I'')
654: or (not exists (select 1
655: from hr_assignment_set_amendments hasa3
656: where hasa3.assignment_set_id = has1.assignment_set_id
657: and hasa3.assignment_id = paf.assignment_id
658: and nvl(hasa3.include_or_exclude,''I'') = ''E'')
659: and not exists (select 1

Line 660: from hr_assignment_set_amendments hasa4

656: where hasa3.assignment_set_id = has1.assignment_set_id
657: and hasa3.assignment_id = paf.assignment_id
658: and nvl(hasa3.include_or_exclude,''I'') = ''E'')
659: and not exists (select 1
660: from hr_assignment_set_amendments hasa4
661: where hasa4.assignment_set_id = has1.assignment_set_id
662: and nvl(hasa4.include_or_exclude,''I'') = ''I'')
663: )
664: )

Line 852: from hr_assignment_set_amendments

848: if asg_set_id is not null then
849: begin
850: select distinct include_or_exclude
851: into v_incl_sw
852: from hr_assignment_set_amendments
853: where assignment_set_id = asg_set_id;
854: exception
855: when no_data_found then
856: v_incl_sw := 'I';

Line 878: from hr_assignment_set_amendments

874: inc_flag varchar2(5);
875: begin
876: select include_or_exclude
877: into inc_flag
878: from hr_assignment_set_amendments
879: where assignment_set_id = asg_set_id
880: and assignment_id = asgrec.assignment_id;
881:
882: if inc_flag = 'E' then