DBA Data[Home] [Help]

APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on FND_DATE

Line 38: fnd_date.date_to_canonical

34: 05-DEC-2001 ssattini 115.2 Fixed bug#2133040.
35: 19-DEC-2001 ssattini 115.3 Fixed bug#2139427,2136857.
36: 21-DEC-2001 ssattini 115.4 Changed 'Pay Date' format
37: using
38: fnd_date.date_to_canonical
39: function.
40: 08-JAN-2002 ssattini 115.5 Fixed bug#2134726, 2133345,
41: 2134807 and 2134821.
42: 28-JAN-2002 ssattini 115.6 Fixed bug#2164160 and printed

Line 1090: open c_assignments( fnd_date.canonical_to_date(p_start_date)

1086: /*****************************************************
1087: ** Start of the Data Section of the Report
1088: *****************************************************/
1089: hr_utility.trace('Before open of c_assignments cursor');
1090: open c_assignments( fnd_date.canonical_to_date(p_start_date)
1091: ,fnd_date.canonical_to_date(p_end_date)
1092: ,p_payroll_id
1093: ,p_consolidation_set_id
1094: ,p_payment_type_id

Line 1091: ,fnd_date.canonical_to_date(p_end_date)

1087: ** Start of the Data Section of the Report
1088: *****************************************************/
1089: hr_utility.trace('Before open of c_assignments cursor');
1090: open c_assignments( fnd_date.canonical_to_date(p_start_date)
1091: ,fnd_date.canonical_to_date(p_end_date)
1092: ,p_payroll_id
1093: ,p_consolidation_set_id
1094: ,p_payment_type_id
1095: ,p_tax_unit_id

Line 1127: open c_payment_period ( fnd_date.canonical_to_date(p_start_date)

1123: exit;
1124: end if;
1125:
1126: hr_utility.trace('Before open of c_payment_period cursor');
1127: open c_payment_period ( fnd_date.canonical_to_date(p_start_date)
1128: ,fnd_date.canonical_to_date(p_end_date)
1129: ,p_business_group_id
1130: ,ln_locked_action_id
1131: ,ln_pre_payment_id

Line 1128: ,fnd_date.canonical_to_date(p_end_date)

1124: end if;
1125:
1126: hr_utility.trace('Before open of c_payment_period cursor');
1127: open c_payment_period ( fnd_date.canonical_to_date(p_start_date)
1128: ,fnd_date.canonical_to_date(p_end_date)
1129: ,p_business_group_id
1130: ,ln_locked_action_id
1131: ,ln_pre_payment_id
1132: );