APPS.PAY_CA_WF_PKG dependencies on FND_DATE

Line 812: and end_date = fnd_date.canonical_to_date(p_date_earned);

808: cursor cur_retro_period is
809: select period_name
810: from per_time_periods
811: where payroll_id = l_payroll_id
812: and end_date = fnd_date.canonical_to_date(p_date_earned);
813:
814: cursor cur_event_group is
815: select event_group_name
816: from pay_event_groups

Line 852: and fnd_date.canonical_to_date(p_date_earned)

848: pay_run_types_f r
849: where r.run_type_id = to_number(p_payroll_run_type)
850: and r.run_type_id = t.run_type_id
851: and t.language = userenv('LANG')
852: and fnd_date.canonical_to_date(p_date_earned)
853: between r.effective_start_date and r.effective_end_date;
854:
855: cursor cur_sdr_reporting_dimension is
856: select meaning

Line 905: and fnd_date.canonical_to_date(p_date_earned)

901: cursor cur_ele_employee is
902: select full_name||'(Person ID='||person_id||')'
903: from per_people_f
904: where person_id = to_number(p_ele_employee)
905: and fnd_date.canonical_to_date(p_date_earned)
906: between effective_start_date and effective_end_date;
907:
908: cursor cur_ded_class is
909: select classification_name

Line 917: and fnd_date.canonical_to_date(p_date_earned)

913: cursor cur_ded_name is
914: select element_name
915: from pay_element_types_f
916: where element_type_id = to_number(p_deduction_name)
917: and fnd_date.canonical_to_date(p_date_earned)
918: between effective_start_date and effective_end_date;
919:
920: cursor cur_reg_dimension is
921: select flv.meaning

Line 971: and fnd_date.canonical_to_date(p_date_earned)

967: cursor cur_roe_worksheet_person is
968: select full_name
969: from per_all_people_f
970: where person_id = to_number(p_roe_worksheet_person)
971: and fnd_date.canonical_to_date(p_date_earned)
972: between effective_start_date and effective_end_date;
973:
974: cursor cur_roe_mag_media_person is
975: select full_name

Line 979: and fnd_date.canonical_to_date(p_date_earned)

975: select full_name
976: from per_all_people_f
977: where person_id =
978: to_number(substr(p_roe_mag_media_person,(length('PERSON_ID=')+1)))
979: and fnd_date.canonical_to_date(p_date_earned)
980: between effective_start_date and effective_end_date;
981:
982: cursor cur_costing_summary_accruals is
983: select meaning

Line 1013: and fnd_date.canonical_to_date(p_date_earned)

1009: from pay_element_types_f el, pay_element_types_f_tl tl
1010: where el.element_type_id = to_number(p_cost_detail_element)
1011: and el.element_type_id = tl.element_type_id
1012: and tl.language = userenv('LANG')
1013: and fnd_date.canonical_to_date(p_date_earned)
1014: between el.effective_start_date and el.effective_end_date;
1015:
1016: cursor cur_costing_detail_asg_set is
1017: select assignment_set_name

Line 1331: select fnd_date.date_to_chardate(effective_date)||'('||to_char(request_id)||')'

1327:
1328: end;
1329:
1330: begin
1331: select fnd_date.date_to_chardate(effective_date)||'('||to_char(request_id)||')'
1332: into lv_payroll_process
1333: from pay_payroll_actions
1334: where payroll_action_id = to_number(p_payroll_process);
1335:

Line 1363: and fnd_date.canonical_to_date(p_date_earned)

1359: select payroll_name
1360: into lv_payroll_name
1361: from pay_all_payrolls_f
1362: where payroll_id = l_payroll_id
1363: and fnd_date.canonical_to_date(p_date_earned)
1364: between effective_start_date and effective_end_date;
1365:
1366: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
1367:

Line 1396: and fnd_date.canonical_to_date(p_date_earned) between

1392: into lv_organization
1393: from per_organization_units
1394: where organization_id = to_number(p_organization)
1395: and business_group_id = p_business_group_id
1396: and fnd_date.canonical_to_date(p_date_earned) between
1397: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1398:
1399:
1400: hr_utility.trace('lv_organization = ' || lv_organization);

Line 1431: and fnd_date.canonical_to_date(p_date_earned) between

1427: into lv_gre_name
1428: from hr_ca_tax_units_v
1429: where tax_unit_id = to_number(p_gre)
1430: and business_group_id = p_business_group_id
1431: and fnd_date.canonical_to_date(p_date_earned) between
1432: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1433:
1434: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
1435:

Line 1455: and fnd_date.canonical_to_date(p_date_earned) between

1451: and hoi.org_information_context = 'CLASS'
1452: and hoi.org_information1 = 'CA_TAX_GROUP'
1453: and hou.business_group_id = p_business_group_id
1454: and hou.organization_id = to_number(p_tax_group)
1455: and fnd_date.canonical_to_date(p_date_earned) between
1456: hou.date_from and nvl(hou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
1457:
1458: hr_utility.trace('lv_tax_group = ' || lv_tax_group);
1459:

Line 2933: and end_date = fnd_date.canonical_to_date(p_date_earned);

2929: cursor cur_retro_period is
2930: select period_name
2931: from per_time_periods
2932: where payroll_id = l_payroll_id
2933: and end_date = fnd_date.canonical_to_date(p_date_earned);
2934:
2935: cursor cur_event_group is
2936: select event_group_name
2937: from pay_event_groups

Line 2981: and fnd_date.canonical_to_date(p_date_earned)

2977: pay_run_types_f r
2978: where r.run_type_id = to_number(p_payroll_run_type)
2979: and r.run_type_id = t.run_type_id
2980: and t.language = userenv('LANG')
2981: and fnd_date.canonical_to_date(p_date_earned)
2982: between r.effective_start_date and r.effective_end_date;
2983:
2984: cursor cur_sdr_reporting_dimension is
2985: select meaning

Line 3034: and fnd_date.canonical_to_date(p_date_earned)

3030: cursor cur_ele_employee is
3031: select full_name||'(Person ID='||person_id||')'
3032: from per_people_f
3033: where person_id = to_number(p_ele_employee)
3034: and fnd_date.canonical_to_date(p_date_earned)
3035: between effective_start_date and effective_end_date;
3036:
3037: cursor cur_ded_class is
3038: select classification_name

Line 3046: and fnd_date.canonical_to_date(p_date_earned)

3042: cursor cur_ded_name is
3043: select element_name
3044: from pay_element_types_f
3045: where element_type_id = to_number(p_deduction_name)
3046: and fnd_date.canonical_to_date(p_date_earned)
3047: between effective_start_date and effective_end_date;
3048:
3049: cursor cur_reg_dimension is
3050: select flv.meaning

Line 3100: and fnd_date.canonical_to_date(p_date_earned)

3096: cursor cur_roe_worksheet_person is
3097: select full_name
3098: from per_all_people_f
3099: where person_id = to_number(p_roe_worksheet_person)
3100: and fnd_date.canonical_to_date(p_date_earned)
3101: between effective_start_date and effective_end_date;
3102:
3103: cursor cur_roe_mag_media_person is
3104: select full_name

Line 3108: and fnd_date.canonical_to_date(p_date_earned)

3104: select full_name
3105: from per_all_people_f
3106: where person_id =
3107: to_number(substr(p_roe_mag_media_person,(length('PERSON_ID=')+1)))
3108: and fnd_date.canonical_to_date(p_date_earned)
3109: between effective_start_date and effective_end_date;
3110:
3111: cursor cur_costing_summary_accruals is
3112: select meaning

Line 3142: and fnd_date.canonical_to_date(p_date_earned)

3138: from pay_element_types_f el, pay_element_types_f_tl tl
3139: where el.element_type_id = to_number(p_cost_detail_element)
3140: and el.element_type_id = tl.element_type_id
3141: and tl.language = userenv('LANG')
3142: and fnd_date.canonical_to_date(p_date_earned)
3143: between el.effective_start_date and el.effective_end_date;
3144:
3145: cursor cur_costing_detail_asg_set is
3146: select assignment_set_name

Line 3467: select fnd_date.date_to_chardate(effective_date)||'('||to_char(request_id)||')'

3463:
3464: end;
3465:
3466: begin
3467: select fnd_date.date_to_chardate(effective_date)||'('||to_char(request_id)||')'
3468: into lv_payroll_process
3469: from pay_payroll_actions
3470: where payroll_action_id = to_number(p_payroll_process);
3471:

Line 3499: and fnd_date.canonical_to_date(p_date_earned)

3495: select payroll_name
3496: into lv_payroll_name
3497: from pay_all_payrolls_f
3498: where payroll_id = l_payroll_id
3499: and fnd_date.canonical_to_date(p_date_earned)
3500: between effective_start_date and effective_end_date;
3501:
3502: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
3503:

Line 3532: and fnd_date.canonical_to_date(p_date_earned) between

3528: into lv_organization
3529: from per_organization_units
3530: where organization_id = to_number(p_organization)
3531: and business_group_id = p_business_group_id
3532: and fnd_date.canonical_to_date(p_date_earned) between
3533: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
3534:
3535:
3536: hr_utility.trace('lv_organization = ' || lv_organization);

Line 3567: and fnd_date.canonical_to_date(p_date_earned) between

3563: into lv_gre_name
3564: from hr_ca_tax_units_v
3565: where tax_unit_id = to_number(p_gre)
3566: and business_group_id = p_business_group_id
3567: and fnd_date.canonical_to_date(p_date_earned) between
3568: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
3569:
3570: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
3571:

Line 3591: and fnd_date.canonical_to_date(p_date_earned) between

3587: and hoi.org_information_context = 'CLASS'
3588: and hoi.org_information1 = 'CA_TAX_GROUP'
3589: and hou.business_group_id = p_business_group_id
3590: and hou.organization_id = to_number(p_tax_group)
3591: and fnd_date.canonical_to_date(p_date_earned) between
3592: hou.date_from and nvl(hou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
3593:
3594: hr_utility.trace('lv_tax_group = ' || lv_tax_group);
3595:

Line 4901: and fnd_date.canonical_to_date(p_effective_date) between

4897: select prl_information7
4898: from pay_payrolls_f
4899: where payroll_id = p_payroll_id
4900: and prl_information_category = 'CA'
4901: and fnd_date.canonical_to_date(p_effective_date) between
4902: effective_start_date and effective_end_date;
4903:
4904: -- get the GRE contact
4905: