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

Line 817: and fnd_date.canonical_to_date(p_date_earned)

813: from pay_element_types_f el, pay_element_types_f_tl tl
814: where el.element_type_id = to_number(p_cost_detail_element)
815: and el.element_type_id = tl.element_type_id
816: and tl.language = userenv('LANG')
817: and fnd_date.canonical_to_date(p_date_earned)
818: between el.effective_start_date and el.effective_end_date;
819:
820: cursor cur_costing_detail_asg_set is
821: select assignment_set_name

Line 990: and fnd_date.canonical_to_date(p_date_earned)

986: -- Payroll Name
987: select payroll_name into lv_payroll_name
988: from pay_all_payrolls_f
989: where payroll_id = p_payroll_id
990: and fnd_date.canonical_to_date(p_date_earned)
991: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
992:
993: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
994: Exception when others then

Line 1061: and fnd_date.canonical_to_date(p_date_earned)

1057: into lv_nacha_pymt_name
1058: from pay_org_payment_methods_f
1059: where business_group_id = p_business_group_id
1060: and org_payment_method_id = p_nacha_payment_method
1061: and fnd_date.canonical_to_date(p_date_earned)
1062: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
1063: hr_utility.trace('lv_nacha_pymt_name = ' || lv_nacha_pymt_name);
1064:
1065: Exception when others then

Line 1078: and fnd_date.canonical_to_date(p_date_earned)

1074: into lv_check_pymt_name
1075: from pay_org_payment_methods_f
1076: where business_group_id = p_business_group_id
1077: and org_payment_method_id = p_check_writer_payment_method
1078: and fnd_date.canonical_to_date(p_date_earned)
1079: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
1080: hr_utility.trace('lv_check_pymt_name = ' || lv_check_pymt_name);
1081: Exception when others then
1082: hr_utility.trace('In exception: OTHERS of Check Org Payment Method Name ');

Line 1094: and fnd_date.canonical_to_date(p_date_earned)

1090: into lv_pre_ovr_pymt_name
1091: from pay_org_payment_methods_f
1092: where business_group_id = p_business_group_id
1093: and org_payment_method_id = p_payment_method_override
1094: and fnd_date.canonical_to_date(p_date_earned)
1095: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
1096: hr_utility.trace('lv_pre_ovr_pymt_name = ' || lv_pre_ovr_pymt_name);
1097: Exception when others then
1098: hr_utility.trace('In exception : OTHERS Pre Org Payment Method Name Override');

Line 2532: and fnd_date.canonical_to_date(p_date_earned)

2528: from pay_element_types_f el, pay_element_types_f_tl tl
2529: where el.element_type_id = to_number(p_cost_detail_element)
2530: and el.element_type_id = tl.element_type_id
2531: and tl.language = userenv('LANG')
2532: and fnd_date.canonical_to_date(p_date_earned)
2533: between el.effective_start_date and el.effective_end_date;
2534:
2535: cursor cur_costing_detail_asg_set is
2536: select assignment_set_name

Line 2713: and fnd_date.canonical_to_date(p_date_earned)

2709: -- Payroll Name
2710: select payroll_name into lv_payroll_name
2711: from pay_all_payrolls_f
2712: where payroll_id = p_payroll_id
2713: and fnd_date.canonical_to_date(p_date_earned)
2714: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2715:
2716: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
2717: Exception when others then

Line 2784: and fnd_date.canonical_to_date(p_date_earned)

2780: into lv_nacha_pymt_name
2781: from pay_org_payment_methods_f
2782: where business_group_id = p_business_group_id
2783: and org_payment_method_id = p_nacha_payment_method
2784: and fnd_date.canonical_to_date(p_date_earned)
2785: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2786: hr_utility.trace('lv_nacha_pymt_name = ' || lv_nacha_pymt_name);
2787:
2788: Exception when others then

Line 2801: and fnd_date.canonical_to_date(p_date_earned)

2797: into lv_check_pymt_name
2798: from pay_org_payment_methods_f
2799: where business_group_id = p_business_group_id
2800: and org_payment_method_id = p_check_writer_payment_method
2801: and fnd_date.canonical_to_date(p_date_earned)
2802: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2803: hr_utility.trace('lv_check_pymt_name = ' || lv_check_pymt_name);
2804: Exception when others then
2805: hr_utility.trace('In exception: OTHERS of Check Org Payment Method Name ');

Line 2817: and fnd_date.canonical_to_date(p_date_earned)

2813: into lv_pre_ovr_pymt_name
2814: from pay_org_payment_methods_f
2815: where business_group_id = p_business_group_id
2816: and org_payment_method_id = p_payment_method_override
2817: and fnd_date.canonical_to_date(p_date_earned)
2818: between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2819: hr_utility.trace('lv_pre_ovr_pymt_name = ' || lv_pre_ovr_pymt_name);
2820: Exception when others then
2821: hr_utility.trace('In exception : OTHERS Pre Org Payment Method Name Override');

Line 4085: and fnd_date.canonical_to_date(l_effective_date) between

4081: select prl.prl_information1
4082: from pay_payrolls_f prl
4083: where prl.payroll_id = ln_payroll_id
4084: and prl.prl_information_category = 'US'
4085: and fnd_date.canonical_to_date(l_effective_date) between
4086: prl.effective_start_date and prl.effective_end_date;
4087:
4088:
4089: -- get the GRE contact