APPS.PAY_WF_PKG dependencies on FND_DATE

Line 549: and fnd_date.canonical_to_date(p_date_earned)

545: from pay_element_types_f el, pay_element_types_f_tl tl
546: where el.element_type_id = to_number(p_cost_detail_element)
547: and el.element_type_id = tl.element_type_id
548: and tl.language = userenv('LANG')
549: and fnd_date.canonical_to_date(p_date_earned)
550: between el.effective_start_date and el.effective_end_date;
551:
552: cursor cur_costing_detail_asg_set is
553: select assignment_set_name

Line 722: and fnd_date.canonical_to_date(p_date_earned)

718: -- Payroll Name
719: select payroll_name into lv_payroll_name
720: from pay_all_payrolls_f
721: where payroll_id = p_payroll_id
722: and fnd_date.canonical_to_date(p_date_earned)
723: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
724:
725: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
726: Exception when others then

Line 793: and fnd_date.canonical_to_date(p_date_earned)

789: into lv_nacha_pymt_name
790: from pay_org_payment_methods_f
791: where business_group_id = p_business_group_id
792: and org_payment_method_id = p_nacha_payment_method
793: and fnd_date.canonical_to_date(p_date_earned)
794: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
795: hr_utility.trace('lv_nacha_pymt_name = ' || lv_nacha_pymt_name);
796:
797: Exception when others then

Line 810: and fnd_date.canonical_to_date(p_date_earned)

806: into lv_check_pymt_name
807: from pay_org_payment_methods_f
808: where business_group_id = p_business_group_id
809: and org_payment_method_id = p_check_writer_payment_method
810: and fnd_date.canonical_to_date(p_date_earned)
811: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
812: hr_utility.trace('lv_check_pymt_name = ' || lv_check_pymt_name);
813: Exception when others then
814: hr_utility.trace('In exception: OTHERS of Check Org Payment Method Name ');

Line 826: and fnd_date.canonical_to_date(p_date_earned)

822: into lv_pre_ovr_pymt_name
823: from pay_org_payment_methods_f
824: where business_group_id = p_business_group_id
825: and org_payment_method_id = p_payment_method_override
826: and fnd_date.canonical_to_date(p_date_earned)
827: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
828: hr_utility.trace('lv_pre_ovr_pymt_name = ' || lv_pre_ovr_pymt_name);
829: Exception when others then
830: hr_utility.trace('In exception : OTHERS Pre Org Payment Method Name Override');

Line 2049: and fnd_date.canonical_to_date(l_effective_date) between

2045: select prl.prl_information1
2046: from pay_payrolls_f prl
2047: where prl.payroll_id = ln_payroll_id
2048: and prl.prl_information_category = 'US'
2049: and fnd_date.canonical_to_date(l_effective_date) between
2050: prl.effective_start_date and prl.effective_end_date;
2051:
2052:
2053: -- get the GRE contact