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

Line 653: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;

649: FUNCTION get_local_unit
650: (p_assignment_id NUMBER
651: , p_effective_date DATE )
652: RETURN VARCHAR2 AS
653: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;
654:
655: CURSOR c_local_unit(p_assignment_id NUMBER , p_effective_date DATE) IS
656: SELECT sck.segment2
657: FROM per_all_assignments_f asg1

Line 658: , hr_soft_coding_keyflex sck

654:
655: CURSOR c_local_unit(p_assignment_id NUMBER , p_effective_date DATE) IS
656: SELECT sck.segment2
657: FROM per_all_assignments_f asg1
658: , hr_soft_coding_keyflex sck
659: WHERE asg1.assignment_id = p_assignment_id
660: AND asg1.soft_coding_keyflex_id=sck.soft_coding_keyflex_id
661: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date;
662: BEGIN

Line 1082: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;

1078: l_accident_insurance_id hr_organization_information.org_information3%TYPE;
1079: l_lc_accident_insurance_pct hr_organization_information.org_information4%TYPE;
1080: l_accident_insurance_pct hr_organization_information.org_information3%TYPE;
1081: l_group_insurance_pct hr_organization_information.org_information3%TYPE;
1082: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;
1083:
1084: CURSOR c_accident_insurance_info( p_business_group_id NUMBER , p_tax_unit_id NUMBER , p_effective_date DATE ) IS
1085: SELECT hoi2.org_information3 org_information3 ,
1086: NVL(hoi2.org_information5,0 ) org_information5 ,

Line 1178: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;

1174: IS
1175:
1176: l_pension_group_id hr_organization_information.org_information_id%TYPE;
1177: l_pension_num hr_organization_information.org_information1%TYPE;
1178: l_local_unit hr_soft_coding_keyflex.segment2%TYPE;
1179: l_pension_rate hr_organization_information.org_information1%TYPE;
1180:
1181: CURSOR c_person_pension_num(p_assignment_id NUMBER , p_effective_date DATE) IS
1182: SELECT PER_INFORMATION15, PER_INFORMATION16, PER_INFORMATION24