APPS.PAY_US_SQWL_GRE dependencies on FND_DATE

Line 166: ld_Quater_end_date:=fnd_date.canonical_to_date(p_effective_date);

162:
163: BEGIN
164:
165: /*hr_utility.trace_on(null,'SQWL');*/
166: ld_Quater_end_date:=fnd_date.canonical_to_date(p_effective_date);
167:
168: /* Handling special condition for NY state: */
169: IF p_state = 'NY' AND to_char(ld_Quater_end_date,'MM') = '12' THEN
170: ld_Quater_start_date := trunc(ld_Quater_end_date,'Y');

Line 172: ld_Quater_start_date:=fnd_date.canonical_to_date(p_quarter);

168: /* Handling special condition for NY state: */
169: IF p_state = 'NY' AND to_char(ld_Quater_end_date,'MM') = '12' THEN
170: ld_Quater_start_date := trunc(ld_Quater_end_date,'Y');
171: ELSE
172: ld_Quater_start_date:=fnd_date.canonical_to_date(p_quarter);
173: END IF;
174:
175:
176: /* ld_Quater_end_date := add_months(trunc(ld_Quater_start_date,'Q'),3)-1; */

Line 249: AND effective_date = fnd_date.canonical_to_date (p_effective_date)

245: SELECT count(1) into l_previous_sqwl_run_check from pay_payroll_actions
246: WHERE report_type = 'SQWL'
247: AND report_qualifier = p_state
248: AND business_group_id = p_business_group_id
249: AND effective_date = fnd_date.canonical_to_date (p_effective_date)
250: AND pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters) = c_get_all_gres_rec.organization_id;
251:
252: hr_utility.trace('l_previous_sqwl_run_check: '||l_previous_sqwl_run_check);
253:

Line 709: ld_Month_end_date:=fnd_date.canonical_to_date(p_effective_date);

705:
706: BEGIN
707:
708: /*hr_utility.trace_on(null,'SMWL');*/
709: ld_Month_end_date:=fnd_date.canonical_to_date(p_effective_date);
710:
711: /* Handling special condition for NY state: */
712: -- IF p_state = 'NY' AND to_char(ld_Quater_end_date,'MM') = '12' THEN
713: -- ld_Month_start_date := trunc(ld_Month_end_date,'Y');

Line 715: ld_Month_start_date:=fnd_date.canonical_to_date(p_month);

711: /* Handling special condition for NY state: */
712: -- IF p_state = 'NY' AND to_char(ld_Quater_end_date,'MM') = '12' THEN
713: -- ld_Month_start_date := trunc(ld_Month_end_date,'Y');
714: -- ELSE
715: ld_Month_start_date:=fnd_date.canonical_to_date(p_month);
716: -- END IF;
717:
718:
719: /* ld_Month_end_date := add_months(trunc(ld_Quater_start_date,'Q'),3)-1; */

Line 792: AND effective_date = fnd_date.canonical_to_date (p_effective_date)

788: SELECT count(1) into l_previous_smwl_run_check from pay_payroll_actions
789: WHERE report_type = 'SMWL'
790: AND report_qualifier = p_state
791: AND business_group_id = p_business_group_id
792: AND effective_date = fnd_date.canonical_to_date (p_effective_date)
793: AND pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters) = c_get_all_gres_rec.organization_id;
794:
795: hr_utility.trace('l_previous_smwl_run_check: '||l_previous_smwl_run_check);
796: