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_US_INV_DED_FORMULAS dependencies on FND_DATE

Line 33: 17-MAY-2004 sdahiya 115.2 3622290 Added fnd_date.canonical_to_date

29: Date Name Vers Bug No Description
30: ----------- ---------- ------ ------- -------------------------------
31: 23-APR-2004 sdahiya 115.0 Created.
32: 12-MAY-2004 sdahiya 115.1 Modified phase to plb.
33: 17-MAY-2004 sdahiya 115.2 3622290 Added fnd_date.canonical_to_date
34: while converting varchar to date.
35: 18-MAY-2004 sdahiya 115.3 2658290, - Moved dedn amount calculation
36: 1481913, from cal_formula_bo to
37: base_formula.

Line 590: default_date := fnd_date.canonical_to_date('0001/01/01');

586: l_proc_name := l_package_name||'BASE_FORMULA';
587:
588: default_number := -9999;
589: default_string := 'NOT ENTERED';
590: default_date := fnd_date.canonical_to_date('0001/01/01');
591: sub_prio_max := 9999;
592: l_garn_fee_max_fee_amt := NULL;
593: GLB_NUM_ELEM := nvl(GLB_NUM_ELEM ,0);
594: lv_allow_value := NULL;

Line 1526: default_date := fnd_date.canonical_to_date('0001/01/01');

1522: BEGIN
1523: l_proc_name := l_package_name||'CAL_FORMULA_SS';
1524: hr_utility.trace('Entering '||l_proc_name);
1525:
1526: default_date := fnd_date.canonical_to_date('0001/01/01');
1527: default_string := 'NOT ENTERED';
1528: default_number := -9999;
1529: INV_DED_OVR_GRN_EX_DI_PCT := default_number;
1530: INV_DED_OVR_GRN_EX_DI_PCT_ARR := default_number;

Line 3341: default_date := fnd_date.canonical_to_date('0001/01/01');

3337: l_proc_name := l_package_name||'CAL_FORMULA_BO';
3338: hr_utility.trace('Entering '||l_proc_name);
3339:
3340: default_number := -9999;
3341: default_date := fnd_date.canonical_to_date('0001/01/01');
3342: sub_prio_max := 9999;
3343: amount := GLB_AMT(P_CTX_ORIGINAL_ENTRY_ID);
3344: percentage := GLB_PCT(P_CTX_ORIGINAL_ENTRY_ID);
3345: num_dependents := GLB_NUM_DEPS(P_CTX_ORIGINAL_ENTRY_ID);

Line 4128: IF ld_entry_start_date >= fnd_date.canonical_to_date('2006/01/01') THEN

4124: IF date_served = default_date THEN
4125: open csr_get_entry_start_date;
4126: fetch csr_get_entry_start_date into ld_entry_start_date;
4127: close csr_get_entry_start_date;
4128: IF ld_entry_start_date >= fnd_date.canonical_to_date('2006/01/01') THEN
4129: lb_use_state_min_wage := TRUE;
4130: DI_state_exemption_amt := GREATEST(DI_state_exemption_amt,
4131: NVL(ln_M_S_factor, GARN_EXEMPTION_MIN_WAGE_FACTOR) * NVL(c_State_Minimum_Wage, c_Federal_Minimum_Wage));
4132: END IF;

Line 4133: ELSIF date_served >= fnd_date.canonical_to_date('2006/01/01') THEN

4129: lb_use_state_min_wage := TRUE;
4130: DI_state_exemption_amt := GREATEST(DI_state_exemption_amt,
4131: NVL(ln_M_S_factor, GARN_EXEMPTION_MIN_WAGE_FACTOR) * NVL(c_State_Minimum_Wage, c_Federal_Minimum_Wage));
4132: END IF;
4133: ELSIF date_served >= fnd_date.canonical_to_date('2006/01/01') THEN
4134: lb_use_state_min_wage := TRUE;
4135: DI_state_exemption_amt := GREATEST(DI_state_exemption_amt,
4136: NVL(ln_M_S_factor, GARN_EXEMPTION_MIN_WAGE_FACTOR) * NVL(c_State_Minimum_Wage, c_Federal_Minimum_Wage));
4137: END IF;

Line 5207: default_date := fnd_date.canonical_to_date('0001/01/01');

5203:
5204: l_proc_name := l_package_name||'CAL_FORMULA_TL';
5205: hr_utility.trace('Entering '||l_proc_name);
5206:
5207: default_date := fnd_date.canonical_to_date('0001/01/01');
5208: sub_prio_max := 9999;
5209: default_number := -9999;
5210: amount := GLB_AMT(P_CTX_ORIGINAL_ENTRY_ID);
5211: filing_status := GLB_FIL_STAT(P_CTX_ORIGINAL_ENTRY_ID);