APPS.PAY_MWS_MAGTAPE_REPORTING dependencies on DUAL

Line 30: -- by skutteti. Individual pre-tax balances has been replaced

26: g_supp_earn_bal_id := Pay_Mag_Utils.Bal_Db_Item(
27: 'SUPPLEMENTAL_EARNINGS_FOR_FIT_SUBJECT_TO_TAX_PER_GRE_QTD');
28: --
29: -- the following has been commented for the pre-tax enhancements
30: -- by skutteti. Individual pre-tax balances has been replaced
31: -- by one balance g_pre_tax_bal_id
32: --
33: --g_def_gre_bal_id := Pay_Mag_Utils.Bal_Db_Item(
34: -- 'DEF_COMP_401K_PER_GRE_QTD');

Line 73: -- Removed individual pre-tax categories and replaced by one generic

69: p_assignment_id,
70: p_effective_end_date);
71: --
72: -- Pre-tax enhancements by skutteti on 10-jul-1999
73: -- Removed individual pre-tax categories and replaced by one generic
74: -- Pre-tax deduction component.
75: --
76: -- l_def_gre_wages := pay_balance_pkg.get_value (g_def_gre_bal_id,
77: -- p_assignment_id,

Line 575: from sys.dual;

571:
572: /* Get the sysdate and assign it as the tape creation date */
573: select (to_char(sysdate,'YYMMDD'))
574: into l_tape_creation_date
575: from sys.dual;
576:
577: /* Get the format to be used to produce the report. */
578:
579: l_format := Pay_Mag_Utils.Lookup_Format(p_effective_date,