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 1072: open c_assignments( fnd_date.canonical_to_date(p_start_date)

1068: /*****************************************************
1069: ** Start of the Data Section of the Report
1070: *****************************************************/
1071: hr_utility.trace('Before open of c_assignments cursor');
1072: open c_assignments( fnd_date.canonical_to_date(p_start_date)
1073: ,fnd_date.canonical_to_date(p_end_date)
1074: ,p_payroll_id
1075: ,p_consolidation_set_id
1076: ,p_payment_type_id

Line 1073: ,fnd_date.canonical_to_date(p_end_date)

1069: ** Start of the Data Section of the Report
1070: *****************************************************/
1071: hr_utility.trace('Before open of c_assignments cursor');
1072: open c_assignments( fnd_date.canonical_to_date(p_start_date)
1073: ,fnd_date.canonical_to_date(p_end_date)
1074: ,p_payroll_id
1075: ,p_consolidation_set_id
1076: ,p_payment_type_id
1077: ,p_tax_unit_id

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

1105: exit;
1106: end if;
1107:
1108: hr_utility.trace('Before open of c_payment_period cursor');
1109: open c_payment_period ( fnd_date.canonical_to_date(p_start_date)
1110: ,fnd_date.canonical_to_date(p_end_date)
1111: ,p_business_group_id
1112: ,ln_locked_action_id
1113: ,ln_pre_payment_id

Line 1110: ,fnd_date.canonical_to_date(p_end_date)

1106: end if;
1107:
1108: hr_utility.trace('Before open of c_payment_period cursor');
1109: open c_payment_period ( fnd_date.canonical_to_date(p_start_date)
1110: ,fnd_date.canonical_to_date(p_end_date)
1111: ,p_business_group_id
1112: ,ln_locked_action_id
1113: ,ln_pre_payment_id
1114: );