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 283: SELECT fnd_number.canonical_to_number(global_value)

279: IS
280:
281: CURSOR cur_nat_min_wg
282: IS
283: SELECT fnd_number.canonical_to_number(global_value)
284: FROM ff_globals_f
285: WHERE GLOBAL_NAME = 'IE_NAT_MIN_WAGE_RATE'
286: AND legislation_code = 'IE'
287: AND g_archive_effective_date BETWEEN effective_start_date AND effective_end_date;

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

1974: (
1975: SELECT
1976: ATTRIBUTE3 EHECS_CATG
1977: ,ATTRIBUTE4 EMP_CATG
1978: --,SUM(fnd_number.canonical_to_number(ATTRIBUTE5)) sum_nmw_bal_val
1979: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE12)) sum_nmw_count_val
1980: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
1981: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
1982: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val

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

1975: SELECT
1976: ATTRIBUTE3 EHECS_CATG
1977: ,ATTRIBUTE4 EMP_CATG
1978: --,SUM(fnd_number.canonical_to_number(ATTRIBUTE5)) sum_nmw_bal_val
1979: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE12)) sum_nmw_count_val
1980: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
1981: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
1982: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
1983: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot

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

1976: ATTRIBUTE3 EHECS_CATG
1977: ,ATTRIBUTE4 EMP_CATG
1978: --,SUM(fnd_number.canonical_to_number(ATTRIBUTE5)) sum_nmw_bal_val
1979: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE12)) sum_nmw_count_val
1980: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
1981: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
1982: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
1983: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
1984: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val

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

1977: ,ATTRIBUTE4 EMP_CATG
1978: --,SUM(fnd_number.canonical_to_number(ATTRIBUTE5)) sum_nmw_bal_val
1979: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE12)) sum_nmw_count_val
1980: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
1981: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
1982: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
1983: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
1984: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
1985: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val

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

1978: --,SUM(fnd_number.canonical_to_number(ATTRIBUTE5)) sum_nmw_bal_val
1979: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE12)) sum_nmw_count_val
1980: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
1981: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
1982: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
1983: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
1984: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
1985: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
1986: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val

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

1979: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE12)) sum_nmw_count_val
1980: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
1981: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
1982: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
1983: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
1984: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
1985: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
1986: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
1987: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val

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

1980: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE6)) sum_regwg_bal_val
1981: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
1982: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
1983: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
1984: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
1985: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
1986: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
1987: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
1988: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val

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

1981: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE7)) sum_ovrt_bal_val
1982: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
1983: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
1984: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
1985: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
1986: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
1987: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
1988: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
1989: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot

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

1982: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE8)) sum_irrb_bal_val
1983: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
1984: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
1985: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
1986: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
1987: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
1988: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
1989: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
1990: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot

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

1983: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE9)) sum_app_wg_bal_val_tot
1984: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
1985: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
1986: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
1987: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
1988: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
1989: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
1990: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
1991: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val

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

1984: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE10)) sum_chrs_bal_val
1985: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
1986: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
1987: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
1988: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
1989: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
1990: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
1991: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
1992: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val

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

1985: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE11)) sum_othr_bal_val
1986: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
1987: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
1988: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
1989: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
1990: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
1991: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
1992: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
1993: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val

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

1986: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE13)) sum_mat_bal_val
1987: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
1988: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
1989: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
1990: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
1991: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
1992: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
1993: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
1994: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val

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

1987: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE14)) sum_sic_bal_val
1988: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
1989: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
1990: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
1991: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
1992: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
1993: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
1994: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
1995: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot

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

1988: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE15)) sum_otl_bal_val
1989: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
1990: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
1991: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
1992: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
1993: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
1994: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
1995: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
1996: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val

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

1989: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE16)) sum_lap_bal_val_tot
1990: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
1991: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
1992: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
1993: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
1994: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
1995: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
1996: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
1997: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val

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

1990: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE17)) sum_pen_bal_val_tot
1991: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
1992: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
1993: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
1994: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
1995: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
1996: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
1997: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
1998: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val

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

1991: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE18)) sum_prsi_bal_val
1992: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
1993: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
1994: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
1995: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
1996: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
1997: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
1998: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
1999: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val

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

1992: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE19)) sum_incct_bal_val
1993: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
1994: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
1995: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
1996: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
1997: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
1998: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
1999: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2000: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val

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

1993: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE20)) sum_red_bal_val
1994: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
1995: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
1996: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
1997: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
1998: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
1999: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2000: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2001: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val

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

1994: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE21)) sum_otsoc_bal_val
1995: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
1996: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
1997: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
1998: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
1999: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2000: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2001: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2002: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val

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

1995: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE22)) sum_ssec_bal_val_tot
1996: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
1997: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
1998: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
1999: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2000: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2001: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2002: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2003: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val

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

1996: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE23)) sum_bik_veh_bal_val
1997: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
1998: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
1999: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2000: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2001: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2002: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2003: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2004: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val

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

1997: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE24)) sum_stks_bal_val
1998: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
1999: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2000: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2001: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2002: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2003: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2004: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2005: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val

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

1998: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE25)) sum_vhi_bal_val
1999: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2000: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2001: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2002: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2003: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2004: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2005: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val
2006: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val

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

1999: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE26)) sum_hse_bal_val
2000: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2001: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2002: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2003: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2004: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2005: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val
2006: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val
2007: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE34)) sum_al_bal_val -- 6856473

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

2000: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE27)) sum_otben_bal_val
2001: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2002: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2003: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2004: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2005: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val
2006: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val
2007: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE34)) sum_al_bal_val -- 6856473
2008: FROM PAY_US_RPT_TOTALS

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

2001: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE28)) sum_tr_sub_bal_val
2002: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2003: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2004: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2005: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val
2006: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val
2007: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE34)) sum_al_bal_val -- 6856473
2008: FROM PAY_US_RPT_TOTALS
2009: WHERE ATTRIBUTE1 = to_char(c_pact_id)

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

2002: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE29)) sum_ot_sub_bal_val
2003: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2004: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2005: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val
2006: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val
2007: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE34)) sum_al_bal_val -- 6856473
2008: FROM PAY_US_RPT_TOTALS
2009: WHERE ATTRIBUTE1 = to_char(c_pact_id)
2010: AND ATTRIBUTE3 IS NOT NULL

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

2003: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE30)) sum_refund_bal_val
2004: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE31)) sum_rbs_er_bal_val
2005: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE32)) sum_prsa_er_bal_val
2006: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE33)) sum_rac_er_bal_val
2007: ,SUM(fnd_number.canonical_to_number(ATTRIBUTE34)) sum_al_bal_val -- 6856473
2008: FROM PAY_US_RPT_TOTALS
2009: WHERE ATTRIBUTE1 = to_char(c_pact_id)
2010: AND ATTRIBUTE3 IS NOT NULL
2011: AND ATTRIBUTE4 IS NOT NULL

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

2089: select
2090: --decode(hoi.org_information1,'MPAP','M','CSSW','C','PTCO','P') EHECS_CATG
2091: decode(hoi.org_information1,'Managers','M','Clerical Workers','C','Production Workers','P') EHECS_CATG
2092: ,decode(hoi.org_information2,'FR','F','PR','P',hoi.org_information2) EMP_CATG
2093: ,SUM(fnd_number.canonical_to_number(hoi.org_information3)) l_nmw
2094: ,SUM(fnd_number.canonical_to_number(hoi.org_information4)) l_regwg
2095: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2096: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2097: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs

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

2090: --decode(hoi.org_information1,'MPAP','M','CSSW','C','PTCO','P') EHECS_CATG
2091: decode(hoi.org_information1,'Managers','M','Clerical Workers','C','Production Workers','P') EHECS_CATG
2092: ,decode(hoi.org_information2,'FR','F','PR','P',hoi.org_information2) EMP_CATG
2093: ,SUM(fnd_number.canonical_to_number(hoi.org_information3)) l_nmw
2094: ,SUM(fnd_number.canonical_to_number(hoi.org_information4)) l_regwg
2095: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2096: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2097: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2098: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr

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

2091: decode(hoi.org_information1,'Managers','M','Clerical Workers','C','Production Workers','P') EHECS_CATG
2092: ,decode(hoi.org_information2,'FR','F','PR','P',hoi.org_information2) EMP_CATG
2093: ,SUM(fnd_number.canonical_to_number(hoi.org_information3)) l_nmw
2094: ,SUM(fnd_number.canonical_to_number(hoi.org_information4)) l_regwg
2095: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2096: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2097: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2098: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2099: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al

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

2092: ,decode(hoi.org_information2,'FR','F','PR','P',hoi.org_information2) EMP_CATG
2093: ,SUM(fnd_number.canonical_to_number(hoi.org_information3)) l_nmw
2094: ,SUM(fnd_number.canonical_to_number(hoi.org_information4)) l_regwg
2095: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2096: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2097: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2098: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2099: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2100: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat

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

2093: ,SUM(fnd_number.canonical_to_number(hoi.org_information3)) l_nmw
2094: ,SUM(fnd_number.canonical_to_number(hoi.org_information4)) l_regwg
2095: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2096: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2097: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2098: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2099: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2100: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2101: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic

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

2094: ,SUM(fnd_number.canonical_to_number(hoi.org_information4)) l_regwg
2095: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2096: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2097: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2098: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2099: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2100: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2101: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2102: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl

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

2095: ,SUM(fnd_number.canonical_to_number(hoi.org_information5)) l_ovrt
2096: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2097: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2098: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2099: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2100: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2101: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2102: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2103: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi

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

2096: ,SUM(fnd_number.canonical_to_number(hoi.org_information6)) l_irrb
2097: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2098: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2099: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2100: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2101: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2102: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2103: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2104: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc

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

2097: ,SUM(fnd_number.canonical_to_number(hoi.org_information12)) l_chrs
2098: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2099: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2100: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2101: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2102: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2103: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2104: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2105: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red

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

2098: ,SUM(fnd_number.canonical_to_number(hoi.org_information7)) l_othr
2099: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2100: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2101: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2102: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2103: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2104: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2105: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2106: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc

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

2099: ,SUM(fnd_number.canonical_to_number(hoi.org_information8)) l_al
2100: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2101: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2102: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2103: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2104: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2105: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2106: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2107: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks

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

2100: ,SUM(fnd_number.canonical_to_number(hoi.org_information9)) l_mat
2101: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2102: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2103: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2104: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2105: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2106: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2107: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2108: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi

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

2101: ,SUM(fnd_number.canonical_to_number(hoi.org_information10)) l_sic
2102: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2103: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2104: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2105: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2106: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2107: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2108: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2109: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse

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

2102: ,SUM(fnd_number.canonical_to_number(hoi.org_information11)) l_otl
2103: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2104: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2105: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2106: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2107: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2108: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2109: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse
2110: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben

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

2103: --,SUM(fnd_number.canonical_to_number(hoi.org_information13)) l_prsi
2104: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2105: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2106: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2107: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2108: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2109: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse
2110: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben
2111: from hr_organization_units hou

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

2104: ,SUM(fnd_number.canonical_to_number(hoi.org_information14)) l_incc
2105: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2106: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2107: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2108: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2109: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse
2110: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben
2111: from hr_organization_units hou
2112: ,hr_organization_information hoi

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

2105: ,SUM(fnd_number.canonical_to_number(hoi.org_information15)) l_red
2106: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2107: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2108: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2109: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse
2110: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben
2111: from hr_organization_units hou
2112: ,hr_organization_information hoi
2113: where hoi.org_information_context='IE_EHECS_OVERRIDE'

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

2106: ,SUM(fnd_number.canonical_to_number(hoi.org_information16)) l_otsoc
2107: ,SUM(fnd_number.canonical_to_number(hoi.org_information17)) l_stks
2108: ,SUM(fnd_number.canonical_to_number(hoi.org_information18)) l_vhi
2109: ,SUM(fnd_number.canonical_to_number(hoi.org_information19)) l_hse
2110: ,SUM(fnd_number.canonical_to_number(hoi.org_information20)) l_otben
2111: from hr_organization_units hou
2112: ,hr_organization_information hoi
2113: where hoi.org_information_context='IE_EHECS_OVERRIDE'
2114: and hoi.organization_id=c_org_id

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

2447: WHERE paa.run_type_id = prt.run_type_id
2448: AND prt.run_method IN ('N','P')
2449: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2450: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2451: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2452: FROM pay_assignment_actions paa,
2453: pay_payroll_actions ppa
2454: WHERE
2455: paa.assignment_id = paaf.assignment_id

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

2556: WHERE paa.run_type_id = prt.run_type_id
2557: AND prt.run_method IN ('N','P')
2558: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2559: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2560: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2561: FROM pay_assignment_actions paa,
2562: pay_payroll_actions ppa
2563: WHERE
2564: paa.assignment_id = paaf.assignment_id

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

2673: WHERE paa.run_type_id = prt.run_type_id
2674: AND prt.run_method IN ('N','P')
2675: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2676: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2677: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2678: FROM pay_assignment_actions paa,
2679: pay_payroll_actions ppa
2680: WHERE
2681: paa.assignment_id = paaf.assignment_id

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

2806: WHERE paa.run_type_id = prt.run_type_id
2807: AND prt.run_method IN ('N','P')
2808: AND g_qtr_start_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2809: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2810: fnd_number.canonical_to_number(max(paa.assignment_action_id)) child_assignment_action_id
2811: FROM pay_assignment_actions paa,
2812: pay_payroll_actions ppa
2813: WHERE
2814: paa.assignment_id = paaf.assignment_id