[Home] [Help]
530: cursor cur_retro_period is
531: select period_name
532: from per_time_periods
533: where payroll_id = l_payroll_id
534: and end_date = fnd_date.canonical_to_date(p_date_earned);
535:
536: cursor cur_event_group is
537: select event_group_name
538: from pay_event_groups
570: pay_run_types_f r
571: where r.run_type_id = to_number(p_payroll_run_type)
572: and r.run_type_id = t.run_type_id
573: and t.language = userenv('LANG')
574: and fnd_date.canonical_to_date(p_date_earned)
575: between r.effective_start_date and r.effective_end_date;
576:
577: cursor cur_sdr_reporting_dimension is
578: select meaning
623: cursor cur_ele_employee is
624: select full_name||'(Person ID='||person_id||')'
625: from per_people_f
626: where person_id = to_number(p_ele_employee)
627: and fnd_date.canonical_to_date(p_date_earned)
628: between effective_start_date and effective_end_date;
629:
630: cursor cur_ded_class is
631: select classification_name
635: cursor cur_ded_name is
636: select element_name
637: from pay_element_types_f
638: where element_type_id = to_number(p_deduction_name)
639: and fnd_date.canonical_to_date(p_date_earned)
640: between effective_start_date and effective_end_date;
641:
642: cursor cur_reg_dimension is
643: select flv.meaning
689: cursor cur_roe_worksheet_person is
690: select full_name
691: from per_all_people_f
692: where person_id = to_number(p_roe_worksheet_person)
693: and fnd_date.canonical_to_date(p_date_earned)
694: between effective_start_date and effective_end_date;
695:
696: cursor cur_roe_mag_media_person is
697: select full_name
697: select full_name
698: from per_all_people_f
699: where person_id =
700: to_number(substr(p_roe_mag_media_person,(length('PERSON_ID=')+1)))
701: and fnd_date.canonical_to_date(p_date_earned)
702: between effective_start_date and effective_end_date;
703:
704: cursor cur_costing_summary_accruals is
705: select meaning
731: from pay_element_types_f el, pay_element_types_f_tl tl
732: where el.element_type_id = to_number(p_cost_detail_element)
733: and el.element_type_id = tl.element_type_id
734: and tl.language = userenv('LANG')
735: and fnd_date.canonical_to_date(p_date_earned)
736: between el.effective_start_date and el.effective_end_date;
737:
738: cursor cur_costing_detail_asg_set is
739: select assignment_set_name
1049:
1050: end;
1051:
1052: begin
1053: select fnd_date.date_to_chardate(effective_date)||'('||to_char(request_id)||')'
1054: into lv_payroll_process
1055: from pay_payroll_actions
1056: where payroll_action_id = to_number(p_payroll_process);
1057:
1081: select payroll_name
1082: into lv_payroll_name
1083: from pay_all_payrolls_f
1084: where payroll_id = l_payroll_id
1085: and fnd_date.canonical_to_date(p_date_earned)
1086: between effective_start_date and effective_end_date;
1087:
1088: hr_utility.trace('lv_payroll_name = ' || lv_payroll_name);
1089:
1114: into lv_organization
1115: from per_organization_units
1116: where organization_id = to_number(p_organization)
1117: and business_group_id = p_business_group_id
1118: and fnd_date.canonical_to_date(p_date_earned) between
1119: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1120:
1121:
1122: hr_utility.trace('lv_organization = ' || lv_organization);
1149: into lv_gre_name
1150: from hr_ca_tax_units_v
1151: where tax_unit_id = to_number(p_gre)
1152: and business_group_id = p_business_group_id
1153: and fnd_date.canonical_to_date(p_date_earned) between
1154: date_from and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
1155:
1156: hr_utility.trace('lv_gre_name = ' || lv_gre_name);
1157:
1173: and hoi.org_information_context = 'CLASS'
1174: and hoi.org_information1 = 'CA_TAX_GROUP'
1175: and hou.business_group_id = p_business_group_id
1176: and hou.organization_id = to_number(p_tax_group)
1177: and fnd_date.canonical_to_date(p_date_earned) between
1178: hou.date_from and nvl(hou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
1179:
1180: hr_utility.trace('lv_tax_group = ' || lv_tax_group);
1181:
2407: select prl_information7
2408: from pay_payrolls_f
2409: where payroll_id = p_payroll_id
2410: and prl_information_category = 'CA'
2411: and fnd_date.canonical_to_date(p_effective_date) between
2412: effective_start_date and effective_end_date;
2413:
2414: -- get the GRE contact
2415: