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_IE_EHECS_REPORT_PKG dependencies on PAY_ACTION_INFORMATION

Line 678: pay_action_information_api.create_action_information

674: END IF;
675:
676: hr_utility.set_location('Before entering record for IE_EHECS_HEADER ', 380);
677:
678: pay_action_information_api.create_action_information
679: ( p_action_information_id => l_action_info_id
680: ,p_action_context_id => pactid
681: ,p_action_context_type => 'PA'
682: ,p_object_version_number => l_ovn

Line 1839: FROM pay_action_information

1835: action_information23 declarant_phone,
1836: action_information24 declarant_email,
1837: action_information25 declare_date,
1838: action_information26 declarant_position
1839: FROM pay_action_information
1840: WHERE action_context_id = c_pact_id
1841: AND action_context_type = 'PA'
1842: AND action_information_category ='IE_EHECS_HEADER';
1843:

Line 2168: FROM pay_action_information

2164: NVL(action_information27,0) l_vac_ot,
2165: NVL(action_information28,0) l_min_paid_mg,
2166: NVL(action_information29,0) l_min_paid_cl,
2167: NVL(action_information30,0) l_min_paid_ot
2168: FROM pay_action_information
2169: WHERE action_context_id = c_pact_id
2170: AND action_context_type = 'PA'
2171: AND action_information_category ='IE_EHECS_PART1';
2172:

Line 2198: FROM pay_action_information

2194: ROUND(NVL(action_information18,0)) l_irr_bonus_pt_ot,
2195: ROUND(NVL(action_information19,0)) l_tot_wg_app_mg,
2196: ROUND(NVL(action_information20,0)) l_tot_wg_app_cl,
2197: ROUND(NVL(action_information21,0)) l_tot_wg_app_ot
2198: FROM pay_action_information
2199: WHERE action_context_id = c_pact_id
2200: AND action_context_type = 'PA'
2201: AND action_information_category ='IE_EHECS_PART2';
2202:

Line 2223: FROM pay_action_information

2219: ROUND(NVL(action_information15,0)) l_contracted_hrs_paid_app_ot,
2220: ROUND(NVL(action_information16,0)) l_ot_hrs_paid_app_mg,
2221: ROUND(NVL(action_information17,0)) l_ot_hrs_paid_app_cl,
2222: ROUND(NVL(action_information18,0)) l_ot_hrs_paid_app_ot
2223: FROM pay_action_information
2224: WHERE action_context_id = c_pact_id
2225: AND action_context_type = 'PA'
2226: AND action_information_category ='IE_EHECS_PART3';
2227:

Line 2257: FROM pay_action_information

2253: ROUND(NVL(action_information24,0)) l_other_leave_pt_ot,
2254: ROUND(NVL(action_information25,0)) l_all_paid_leave_app_mg,
2255: ROUND(NVL(action_information26,0)) l_all_paid_leave_app_cl,
2256: ROUND(NVL(action_information27,0)) l_all_paid_leave_app_ot
2257: FROM pay_action_information
2258: WHERE action_context_id = c_pact_id
2259: AND action_context_type = 'PA'
2260: AND action_information_category ='IE_EHECS_PART4';
2261:

Line 2279: FROM pay_action_information

2275: ROUND(NVL(action_information12,0)) l_other_paid_ot,
2276: ROUND(NVL(action_information13,0)) l_ssc_contributions_app_mg,
2277: ROUND(NVL(action_information14,0)) l_ssc_contributions_app_cl,
2278: ROUND(NVL(action_information15,0)) l_ssc_contributions_app_ot
2279: FROM pay_action_information
2280: WHERE action_context_id = c_pact_id
2281: AND action_context_type = 'PA'
2282: AND action_information_category ='IE_EHECS_PART7';
2283:

Line 2301: FROM pay_action_information

2297: ROUND(NVL(action_information12,0)) l_staff_housing_ot,
2298: ROUND(NVL(action_information13,0)) l_other_benefits_mg,
2299: ROUND(NVL(action_information14,0)) l_other_benefits_cl,
2300: ROUND(NVL(action_information15,0)) l_other_benefits_ot
2301: FROM pay_action_information
2302: WHERE action_context_id = c_pact_id
2303: AND action_context_type = 'PA'
2304: AND action_information_category ='IE_EHECS_PART8';
2305:

Line 2320: FROM pay_action_information

2316: ROUND(NVL(action_information9,0)) l_refunds,
2317: action_information10 l_comment_line1,
2318: action_information11 l_comment_line2,
2319: action_information12 l_comment_line3
2320: FROM pay_action_information
2321: WHERE action_context_id = c_pact_id
2322: AND action_context_type = 'PA'
2323: AND action_information_category ='IE_EHECS_ALL_OTHER';
2324:

Line 3079: pay_action_information_api.create_action_information

3075:
3076: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3180);
3077: hr_utility.set_location('Before Inserting IE_EHECS_PART1 ',3190);
3078:
3079: pay_action_information_api.create_action_information
3080: ( p_action_information_id => l_action_info_id
3081: ,p_action_context_id => l_payroll_action_id
3082: ,p_action_context_type => 'PA'
3083: ,p_object_version_number => l_ovn

Line 3136: pay_action_information_api.create_action_information

3132: + NVL(l_tab_get_override_totals('P').l_sum_irrb_at,NVL(l_tab_get_totals('P').irrb_at_mg_cl_ot,0));
3133:
3134: hr_utility.set_location('Before Inserting IE_EHECS_PART2 ',3210);
3135:
3136: pay_action_information_api.create_action_information
3137: ( p_action_information_id => l_action_info_id
3138: ,p_action_context_id => l_payroll_action_id
3139: ,p_action_context_type => 'PA'
3140: ,p_object_version_number => l_ovn

Line 3170: pay_action_information_api.create_action_information

3166: );
3167:
3168: hr_utility.set_location('After Inserting IE_EHECS_PART2 ',3220);
3169:
3170: pay_action_information_api.create_action_information
3171: ( p_action_information_id => l_action_info_id
3172: ,p_action_context_id => l_payroll_action_id
3173: ,p_action_context_type => 'PA'
3174: ,p_object_version_number => l_ovn

Line 3233: pay_action_information_api.create_action_information

3229:
3230: hr_utility.set_location(' l_tab_get_totals:M.al_pt_mg_cl_ot ' || l_tab_get_totals('M').al_pt_mg_cl_ot,3230);
3231: hr_utility.set_location(' l_tab_get_totals:C.al_pt_mg_cl_ot ' || l_tab_get_totals('C').al_pt_mg_cl_ot,3230);
3232: hr_utility.set_location(' l_tab_get_totals:Pal_pt_mg_cl_ot ' || l_tab_get_totals('P').al_pt_mg_cl_ot,3230);
3233: pay_action_information_api.create_action_information
3234: ( p_action_information_id => l_action_info_id
3235: ,p_action_context_id => l_payroll_action_id
3236: ,p_action_context_type => 'PA'
3237: ,p_object_version_number => l_ovn

Line 3290: pay_action_information_api.create_action_information

3286: + NVL(l_tab_get_override_totals('P').l_sum_otsoc_at,NVL(l_tab_get_totals('P').otsoc_at_mg_cl_ot,0));
3287:
3288: hr_utility.set_location('Before Inserting IE_EHECS_PART7 ',3260);
3289:
3290: pay_action_information_api.create_action_information
3291: ( p_action_information_id => l_action_info_id
3292: ,p_action_context_id => l_payroll_action_id
3293: ,p_action_context_type => 'PA'
3294: ,p_object_version_number => l_ovn

Line 3318: pay_action_information_api.create_action_information

3314: );
3315:
3316: hr_utility.set_location('After Inserting IE_EHECS_PART7 ',3270);
3317:
3318: pay_action_information_api.create_action_information
3319: ( p_action_information_id => l_action_info_id
3320: ,p_action_context_id => l_payroll_action_id
3321: ,p_action_context_type => 'PA'
3322: ,p_object_version_number => l_ovn

Line 3346: pay_action_information_api.create_action_information

3342: );
3343:
3344: hr_utility.set_location('After Inserting IE_EHECS_PART8 ',3270);
3345:
3346: pay_action_information_api.create_action_information
3347: ( p_action_information_id => l_action_info_id
3348: ,p_action_context_id => l_payroll_action_id
3349: ,p_action_context_type => 'PA'
3350: ,p_object_version_number => l_ovn