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 FND_NUMBER

Line 324: SELECT fnd_number.canonical_to_number(global_value)

320: IS
321:
322: CURSOR cur_nat_min_wg
323: IS
324: SELECT fnd_number.canonical_to_number(global_value)
325: FROM ff_globals_f
326: WHERE GLOBAL_NAME = 'IE_NAT_MIN_WAGE_RATE'
327: AND legislation_code = 'IE'
328: AND g_archive_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 1153: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

1149: CURSOR cur_valid_asg_act(p_asg_id NUMBER, p_payroll_id NUMBER)
1150: IS
1151: SELECT /*+ USE_NL(paa, ppa) */
1152: -- max(paa.assignment_action_id) assignment_action_id
1153: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1154: paa.assignment_action_id),16)) assignment_action_id /* 9852564 */
1155: FROM pay_assignment_actions paa,
1156: pay_payroll_actions ppa
1157: WHERE paa.assignment_id = p_asg_id

Line 2261: --,SUM(fnd_number.canonical_to_number(ATTRIBUTE5)) sum_nmw_bal_val

2257: (
2258: SELECT
2259: ATTRIBUTE3 EHECS_CATG
2260: ,ATTRIBUTE4 EMP_CATG
2261: --,SUM(fnd_number.canonical_to_number(ATTRIBUTE5)) sum_nmw_bal_val
2262: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE12)) sum_nmw_count_val
2263: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
2264: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
2265: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val

Line 2262: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE12)) sum_nmw_count_val

2258: SELECT
2259: ATTRIBUTE3 EHECS_CATG
2260: ,ATTRIBUTE4 EMP_CATG
2261: --,SUM(fnd_number.canonical_to_number(ATTRIBUTE5)) sum_nmw_bal_val
2262: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE12)) sum_nmw_count_val
2263: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
2264: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
2265: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
2266: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot

Line 2263: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val

2259: ATTRIBUTE3 EHECS_CATG
2260: ,ATTRIBUTE4 EMP_CATG
2261: --,SUM(fnd_number.canonical_to_number(ATTRIBUTE5)) sum_nmw_bal_val
2262: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE12)) sum_nmw_count_val
2263: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
2264: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
2265: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
2266: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
2267: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val

Line 2264: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val

2260: ,ATTRIBUTE4 EMP_CATG
2261: --,SUM(fnd_number.canonical_to_number(ATTRIBUTE5)) sum_nmw_bal_val
2262: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE12)) sum_nmw_count_val
2263: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
2264: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
2265: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
2266: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
2267: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
2268: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val

Line 2265: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val

2261: --,SUM(fnd_number.canonical_to_number(ATTRIBUTE5)) sum_nmw_bal_val
2262: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE12)) sum_nmw_count_val
2263: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
2264: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
2265: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
2266: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
2267: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
2268: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
2269: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val

Line 2266: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot

2262: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE12)) sum_nmw_count_val
2263: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
2264: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
2265: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
2266: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
2267: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
2268: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
2269: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
2270: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val

Line 2267: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val

2263: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
2264: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
2265: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
2266: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
2267: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
2268: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
2269: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
2270: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
2271: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val

Line 2268: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val

2264: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
2265: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
2266: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
2267: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
2268: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
2269: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
2270: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
2271: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
2272: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot

Line 2269: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val

2265: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
2266: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
2267: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
2268: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
2269: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
2270: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
2271: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
2272: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
2273: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot

Line 2270: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val

2266: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
2267: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
2268: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
2269: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
2270: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
2271: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
2272: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
2273: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
2274: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val

Line 2271: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val

2267: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
2268: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
2269: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
2270: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
2271: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
2272: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
2273: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
2274: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
2275: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val

Line 2272: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot

2268: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
2269: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
2270: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
2271: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
2272: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
2273: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
2274: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
2275: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
2276: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val

Line 2273: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot

2269: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
2270: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
2271: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
2272: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
2273: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
2274: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
2275: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
2276: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
2277: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val

Line 2274: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val

2270: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
2271: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
2272: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
2273: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
2274: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
2275: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
2276: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
2277: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
2278: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot

Line 2275: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val

2271: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
2272: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
2273: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
2274: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
2275: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
2276: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
2277: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
2278: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
2279: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val

Line 2276: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val

2272: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
2273: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
2274: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
2275: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
2276: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
2277: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
2278: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
2279: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
2280: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val

Line 2277: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val

2273: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
2274: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
2275: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
2276: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
2277: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
2278: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
2279: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
2280: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
2281: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val

Line 2278: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot

2274: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
2275: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
2276: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
2277: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
2278: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
2279: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
2280: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
2281: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
2282: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val

Line 2279: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val

2275: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
2276: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
2277: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
2278: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
2279: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
2280: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
2281: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
2282: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2283: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val

Line 2280: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val

2276: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
2277: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
2278: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
2279: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
2280: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
2281: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
2282: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2283: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2284: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val

Line 2281: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val

2277: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
2278: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
2279: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
2280: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
2281: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
2282: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2283: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2284: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2285: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val

Line 2282: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val

2278: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
2279: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
2280: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
2281: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
2282: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2283: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2284: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2285: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2286: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val

Line 2283: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val

2279: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
2280: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
2281: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
2282: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2283: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2284: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2285: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2286: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2287: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val

Line 2284: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val

2280: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
2281: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
2282: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2283: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2284: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2285: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2286: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2287: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2288: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val

Line 2285: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val

2281: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
2282: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2283: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2284: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2285: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2286: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2287: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2288: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val
2289: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val

Line 2286: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val

2282: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2283: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2284: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2285: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2286: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2287: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2288: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val
2289: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val
2290: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE34)) sum_al_bal_val -- 6856473

Line 2287: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val

2283: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2284: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2285: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2286: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2287: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2288: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val
2289: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val
2290: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE34)) sum_al_bal_val -- 6856473
2291: FROM PAY_US_RPT_TOTALS

Line 2288: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val

2284: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2285: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2286: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2287: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2288: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val
2289: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val
2290: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE34)) sum_al_bal_val -- 6856473
2291: FROM PAY_US_RPT_TOTALS
2292: WHERE ATTRIBUTE1 = to_char(c_pact_id)

Line 2289: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val

2285: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2286: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2287: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2288: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val
2289: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val
2290: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE34)) sum_al_bal_val -- 6856473
2291: FROM PAY_US_RPT_TOTALS
2292: WHERE ATTRIBUTE1 = to_char(c_pact_id)
2293: AND ATTRIBUTE3 IS NOT NULL

Line 2290: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE34)) sum_al_bal_val -- 6856473

2286: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2287: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2288: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val
2289: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val
2290: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE34)) sum_al_bal_val -- 6856473
2291: FROM PAY_US_RPT_TOTALS
2292: WHERE ATTRIBUTE1 = to_char(c_pact_id)
2293: AND ATTRIBUTE3 IS NOT NULL
2294: AND ATTRIBUTE4 IS NOT NULL

Line 2376: ,SUM(fnd_number.canonical_to_number(hoi.org_information3)) l_nmw

2372: select
2373: --decode(hoi.org_information1,'MPAP','M','CSSW','C','PTCO','P') EHECS_CATG
2374: decode(hoi.org_information1,'Managers','M','Clerical Workers','C','Production Workers','P') EHECS_CATG
2375: ,decode(hoi.org_information2,'FR','F','PR','P',hoi.org_information2) EMP_CATG
2376: ,SUM(fnd_number.canonical_to_number(hoi.org_information3)) l_nmw
2377: ,SUM(fnd_number.canonical_to_number(hoi.org_information4)) l_regwg
2378: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2379: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2380: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs

Line 2377: ,SUM(fnd_number.canonical_to_number(hoi.org_information4)) l_regwg

2373: --decode(hoi.org_information1,'MPAP','M','CSSW','C','PTCO','P') EHECS_CATG
2374: decode(hoi.org_information1,'Managers','M','Clerical Workers','C','Production Workers','P') EHECS_CATG
2375: ,decode(hoi.org_information2,'FR','F','PR','P',hoi.org_information2) EMP_CATG
2376: ,SUM(fnd_number.canonical_to_number(hoi.org_information3)) l_nmw
2377: ,SUM(fnd_number.canonical_to_number(hoi.org_information4)) l_regwg
2378: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2379: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2380: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2381: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr

Line 2378: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt

2374: decode(hoi.org_information1,'Managers','M','Clerical Workers','C','Production Workers','P') EHECS_CATG
2375: ,decode(hoi.org_information2,'FR','F','PR','P',hoi.org_information2) EMP_CATG
2376: ,SUM(fnd_number.canonical_to_number(hoi.org_information3)) l_nmw
2377: ,SUM(fnd_number.canonical_to_number(hoi.org_information4)) l_regwg
2378: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2379: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2380: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2381: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2382: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al

Line 2379: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb

2375: ,decode(hoi.org_information2,'FR','F','PR','P',hoi.org_information2) EMP_CATG
2376: ,SUM(fnd_number.canonical_to_number(hoi.org_information3)) l_nmw
2377: ,SUM(fnd_number.canonical_to_number(hoi.org_information4)) l_regwg
2378: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2379: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2380: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2381: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2382: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2383: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat

Line 2380: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs

2376: ,SUM(fnd_number.canonical_to_number(hoi.org_information3)) l_nmw
2377: ,SUM(fnd_number.canonical_to_number(hoi.org_information4)) l_regwg
2378: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2379: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2380: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2381: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2382: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2383: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2384: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic

Line 2381: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr

2377: ,SUM(fnd_number.canonical_to_number(hoi.org_information4)) l_regwg
2378: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2379: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2380: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2381: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2382: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2383: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2384: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2385: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl

Line 2382: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al

2378: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2379: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2380: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2381: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2382: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2383: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2384: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2385: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2386: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi

Line 2383: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat

2379: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2380: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2381: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2382: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2383: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2384: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2385: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2386: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2387: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc

Line 2384: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic

2380: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2381: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2382: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2383: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2384: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2385: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2386: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2387: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2388: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red

Line 2385: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl

2381: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2382: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2383: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2384: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2385: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2386: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2387: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2388: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2389: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc

Line 2386: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi

2382: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2383: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2384: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2385: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2386: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2387: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2388: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2389: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2390: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks

Line 2387: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc

2383: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2384: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2385: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2386: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2387: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2388: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2389: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2390: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2391: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi

Line 2388: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red

2384: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2385: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2386: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2387: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2388: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2389: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2390: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2391: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2392: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse

Line 2389: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc

2385: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2386: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2387: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2388: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2389: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2390: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2391: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2392: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse
2393: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben

Line 2390: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks

2386: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2387: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2388: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2389: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2390: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2391: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2392: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse
2393: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben
2394: from hr_organization_units hou

Line 2391: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi

2387: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2388: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2389: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2390: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2391: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2392: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse
2393: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben
2394: from hr_organization_units hou
2395: ,hr_organization_information hoi

Line 2392: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse

2388: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2389: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2390: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2391: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2392: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse
2393: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben
2394: from hr_organization_units hou
2395: ,hr_organization_information hoi
2396: where hoi.org_information_context='IE_EHECS_OVERRIDE'

Line 2393: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben

2389: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2390: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2391: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2392: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse
2393: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben
2394: from hr_organization_units hou
2395: ,hr_organization_information hoi
2396: where hoi.org_information_context='IE_EHECS_OVERRIDE'
2397: and hoi.organization_id=c_org_id

Line 2734: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id

2730: WHERE paa.run_type_id = prt.run_type_id
2731: AND prt.run_method IN ('N','P')
2732: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2733: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2734: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2735: FROM pay_assignment_actions paa,
2736: pay_payroll_actions ppa
2737: WHERE
2738: paa.assignment_id = paaf.assignment_id

Line 2845: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id

2841: WHERE paa.run_type_id = prt.run_type_id
2842: AND prt.run_method IN ('N','P')
2843: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2844: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2845: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2846: FROM pay_assignment_actions paa,
2847: pay_payroll_actions ppa
2848: WHERE
2849: paa.assignment_id = paaf.assignment_id

Line 2964: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id

2960: WHERE paa.run_type_id = prt.run_type_id
2961: AND prt.run_method IN ('N','P')
2962: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2963: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2964: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2965: FROM pay_assignment_actions paa,
2966: pay_payroll_actions ppa
2967: WHERE
2968: paa.assignment_id = paaf.assignment_id

Line 3097: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id

3093: WHERE paa.run_type_id = prt.run_type_id
3094: AND prt.run_method IN ('N','P')
3095: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
3096: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
3097: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
3098: FROM pay_assignment_actions paa,
3099: pay_payroll_actions ppa
3100: WHERE
3101: paa.assignment_id = paaf.assignment_id