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.HR_NL_EXTRA_ASG_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 79: FROM per_all_assignments_f asg

75: SELECT scl.segment11 tax_code
76: ,scl.segment4 tax_red
77: ,scl.segment7 labour_tax
78: ,scl.segment9 add_sr_tax
79: FROM per_all_assignments_f asg
80: ,hr_soft_coding_keyflex scl
81: WHERE asg.assignment_id = p_assignment_id
82: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
83: AND p_effective_date

Line 319: FROM per_all_assignments_f asg

315:
316: CURSOR csr_get_spl_indicator_details (p_assignment_id NUMBER
317: ,p_effective_date DATE) IS
318: SELECT scl.segment10 special_indicator
319: FROM per_all_assignments_f asg
320: ,hr_soft_coding_keyflex scl
321: WHERE asg.assignment_id = p_assignment_id
322: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
323: AND p_effective_date

Line 455: FROM per_all_assignments_f asg

451: SELECT scl.segment2 emp_type
452: ,scl.segment3 emp_sub_type
453: ,scl.segment21 commencing_from
454: ,scl.segment23 date_ending
455: FROM per_all_assignments_f asg
456: ,hr_soft_coding_keyflex scl
457: WHERE asg.assignment_id = p_assignment_id
458: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
459: AND p_effective_date

Line 657: FROM per_all_assignments_f paa

653:
654: CURSOR csr_get_asg_details(p_assignment_id NUMBER
655: ,p_effective_date DATE) IS
656: SELECT paa.establishment_id, paa.payroll_id
657: FROM per_all_assignments_f paa
658: WHERE paa.assignment_id = p_assignment_id
659: AND p_effective_date BETWEEN paa.effective_start_date
660: AND paa.effective_end_date;
661:

Line 678: l_old_employer per_all_assignments_f.establishment_id%TYPE;

674: AND ppf.effective_end_date;
675:
676: l_asg_action_exists VARCHAR2(1);
677: l_asg_details csr_get_asg_details%ROWTYPE;
678: l_old_employer per_all_assignments_f.establishment_id%TYPE;
679: l_new_employer per_all_assignments_f.establishment_id%TYPE;
680: l_emp_chg_flag VARCHAR2(1);
681:
682: BEGIN

Line 679: l_new_employer per_all_assignments_f.establishment_id%TYPE;

675:
676: l_asg_action_exists VARCHAR2(1);
677: l_asg_details csr_get_asg_details%ROWTYPE;
678: l_old_employer per_all_assignments_f.establishment_id%TYPE;
679: l_new_employer per_all_assignments_f.establishment_id%TYPE;
680: l_emp_chg_flag VARCHAR2(1);
681:
682: BEGIN
683: --hr_utility.trace('Entering validate_employer_change');

Line 935: FROM per_all_assignments_f asg

931: p_assignment_id NUMBER
932: ,p_effective_date DATE) IS
933: SELECT scl.segment21 commencing_date
934: ,scl.segment23 date_ending
935: FROM per_all_assignments_f asg
936: ,hr_soft_coding_keyflex scl
937: WHERE asg.assignment_id = p_assignment_id
938: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
939: AND p_effective_date

Line 946: from per_all_assignments_f PAA

942: date_details_rec csr_get_date_details%ROWTYPE;
943:
944: cursor csr_asg is
945: select payroll_id,person_id,business_group_id
946: from per_all_assignments_f PAA
947: where assignment_id=p_assignment_id and
948: p_effective_date between PAA.effective_start_date and PAA.effective_end_date;
949:
950: cursor csr_freq is

Line 952: from per_all_assignments_f PAA

948: p_effective_date between PAA.effective_start_date and PAA.effective_end_date;
949:
950: cursor csr_freq is
951: select frequency
952: from per_all_assignments_f PAA
953: where assignment_id=p_assignment_id and
954: p_effective_date between PAA.effective_start_date and PAA.effective_end_date;
955:
956: