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

Line 884: ,hr_soft_coding_keyflex hsc

880: ,hsc.segment10
881: ,hsc.segment11
882: ,hsc.segment12
883: FROM per_assignments_f paf
884: ,hr_soft_coding_keyflex hsc
885: WHERE paf.assignment_id = p_assignment_id
886: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
887: AND paf.business_group_id = p_business_group_id
888: AND p_date BETWEEN paf.effective_start_date

Line 891: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;

887: AND paf.business_group_id = p_business_group_id
888: AND p_date BETWEEN paf.effective_start_date
889: AND paf.effective_end_date;
890:
891: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
892: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;

Line 892: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;

888: AND p_date BETWEEN paf.effective_start_date
889: AND paf.effective_end_date;
890:
891: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
892: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;

Line 893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;

889: AND paf.effective_end_date;
890:
891: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
892: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;

Line 894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;

890:
891: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
892: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;

Line 895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;

891: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
892: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;

Line 896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;

892: l_segment2 hr_soft_coding_keyflex.segment1%TYPE;
893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;

Line 897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;

893: l_segment3 hr_soft_coding_keyflex.segment1%TYPE;
894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;
901: l_segment11 hr_soft_coding_keyflex.segment1%TYPE;

Line 898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;

894: l_segment4 hr_soft_coding_keyflex.segment1%TYPE;
895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;
901: l_segment11 hr_soft_coding_keyflex.segment1%TYPE;
902: l_segment12 hr_soft_coding_keyflex.segment1%TYPE;

Line 899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;

895: l_segment5 hr_soft_coding_keyflex.segment1%TYPE;
896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;
901: l_segment11 hr_soft_coding_keyflex.segment1%TYPE;
902: l_segment12 hr_soft_coding_keyflex.segment1%TYPE;
903: l_message VARCHAR2(255);

Line 900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;

896: l_segment6 hr_soft_coding_keyflex.segment1%TYPE;
897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;
901: l_segment11 hr_soft_coding_keyflex.segment1%TYPE;
902: l_segment12 hr_soft_coding_keyflex.segment1%TYPE;
903: l_message VARCHAR2(255);
904: l_procedure VARCHAR2(100);

Line 901: l_segment11 hr_soft_coding_keyflex.segment1%TYPE;

897: l_segment7 hr_soft_coding_keyflex.segment1%TYPE;
898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;
901: l_segment11 hr_soft_coding_keyflex.segment1%TYPE;
902: l_segment12 hr_soft_coding_keyflex.segment1%TYPE;
903: l_message VARCHAR2(255);
904: l_procedure VARCHAR2(100);
905:

Line 902: l_segment12 hr_soft_coding_keyflex.segment1%TYPE;

898: l_segment8 hr_soft_coding_keyflex.segment1%TYPE;
899: l_segment9 hr_soft_coding_keyflex.segment1%TYPE;
900: l_segment10 hr_soft_coding_keyflex.segment1%TYPE;
901: l_segment11 hr_soft_coding_keyflex.segment1%TYPE;
902: l_segment12 hr_soft_coding_keyflex.segment1%TYPE;
903: l_message VARCHAR2(255);
904: l_procedure VARCHAR2(100);
905:
906: BEGIN

Line 1402: hr_soft_coding_keyflex scl

1398: CURSOR c_gre_id
1399: IS
1400: SELECT scl.segment1
1401: FROM per_assignments_f asg,
1402: hr_soft_coding_keyflex scl
1403: WHERE asg.assignment_id = p_assignment_id
1404: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1405: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
1406:

Line 1407: l_tax_unit_id hr_soft_coding_keyflex.segment1%TYPE;

1403: WHERE asg.assignment_id = p_assignment_id
1404: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
1405: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
1406:
1407: l_tax_unit_id hr_soft_coding_keyflex.segment1%TYPE;
1408: BEGIN
1409: OPEN c_gre_id;
1410: FETCH c_gre_id INTO l_tax_unit_id;
1411: CLOSE c_gre_id;