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_AU_PAYE_FF dependencies on HR_SOFT_CODING_KEYFLEX

Line 437: hr_soft_coding_keyflex hsck

433:
434: cursor get_legal_emp_start_date (c_assignment_id per_all_assignments_f.assignment_id%type) is
435: select min(effective_start_date)
436: from per_all_assignments_f paf,
437: hr_soft_coding_keyflex hsck
438: where paf.assignment_id = c_assignment_id
439: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
440: and hsck.segment1 = fnd_number.number_to_canonical(p_tax_unit_id) -- Bug 13793176
441: AND paf.effective_start_date <= l_period_end

Line 459: hr_soft_coding_keyflex hsck

455: from per_time_periods ptp
456: ,per_time_periods ptp1
457: where exists (select 'EXISTS' from
458: per_assignments_f paf,
459: hr_soft_coding_keyflex hsck
460: where paf.assignment_id = p_assignment_id
461: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
462: and hsck.segment1 = p_tax_unit_id
463: AND paf.effective_start_date <= l_period_end

Line 808: hr_soft_coding_keyflex hsck

804: select count(DISTINCT ptp.time_period_id)
805: from per_time_periods ptp
806: where exists (select 'EXISTS' from
807: per_assignments_f paf,
808: hr_soft_coding_keyflex hsck
809: where paf.assignment_id = p_assignment_id
810: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
811: and hsck.segment1 = c_tax_unit_id
812: AND paf.effective_start_date <= c_end_date

Line 832: hr_soft_coding_keyflex hsck

828: select count(DISTINCT ptp.time_period_id)
829: from per_time_periods ptp
830: where exists (select 'EXISTS' from
831: per_assignments_f paf,
832: hr_soft_coding_keyflex hsck
833: where paf.assignment_id = p_assignment_id
834: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
835: and hsck.segment1 = c_tax_unit_id
836: AND paf.effective_start_date <= c_end_date

Line 853: hr_soft_coding_keyflex hsck

849: select count(DISTINCT ptp.time_period_id)
850: from per_time_periods ptp
851: where exists (select 'EXISTS' from
852: per_assignments_f paf,
853: hr_soft_coding_keyflex hsck
854: where paf.assignment_id = p_assignment_id
855: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
856: and hsck.segment1 = c_tax_unit_id
857: AND paf.effective_start_date <= c_end_date

Line 4549: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

4545: l_cagr_grade_def_id number;
4546: l_cagr_concatenated_segments varchar2(2000);
4547: l_comment_id number;
4548: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type;
4549: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
4550: l_no_managers_warning boolean;
4551: l_other_manager_warning boolean;
4552: not_inserted boolean := TRUE;
4553:

Line 4768: from hr_soft_coding_keyflex

4764:
4765: CURSOR csr_get_le_id(p_hr_soft_id IN NUMBER)
4766: IS
4767: SELECT SEGMENT1
4768: from hr_soft_coding_keyflex
4769: where SOFT_CODING_KEYFLEX_ID = p_hr_soft_id;
4770:
4771: CURSOR csr_get_loading_flag(p_hr_soft_id IN NUMBER)
4772: IS

Line 4774: from hr_soft_coding_keyflex

4770:
4771: CURSOR csr_get_loading_flag(p_hr_soft_id IN NUMBER)
4772: IS
4773: SELECT SEGMENT2
4774: from hr_soft_coding_keyflex
4775: where SOFT_CODING_KEYFLEX_ID = p_hr_soft_id;
4776:
4777: -- cursor for first record of assignment
4778: cursor fut_fir_asg_rec(p_assignment_id IN NUMBER) IS