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 834: FROM per_all_assignments_f asg

830: p_assignment_id NUMBER
831: ,p_effective_date DATE) IS
832: SELECT scl.segment21 commencing_date
833: ,scl.segment23 date_ending
834: FROM per_all_assignments_f asg
835: ,hr_soft_coding_keyflex scl
836: WHERE asg.assignment_id = p_assignment_id
837: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
838: AND p_effective_date

Line 845: from per_all_assignments_f PAA

841: date_details_rec csr_get_date_details%ROWTYPE;
842:
843: cursor csr_asg is
844: select payroll_id,person_id
845: from per_all_assignments_f PAA
846: where assignment_id=p_assignment_id and
847: p_effective_date between PAA.effective_start_date and PAA.effective_end_date;
848:
849: cursor csr_freq is

Line 851: from per_all_assignments_f PAA

847: p_effective_date between PAA.effective_start_date and PAA.effective_end_date;
848:
849: cursor csr_freq is
850: select frequency
851: from per_all_assignments_f PAA
852: where assignment_id=p_assignment_id and
853: p_effective_date between PAA.effective_start_date and PAA.effective_end_date;
854:
855: