APPS.PAY_CA_WF_PKG dependencies on HR_ASSIGNMENT_SETS

Line 823: from hr_assignment_sets

819: to_number(substr(p_retro_event_group,(length('EVT_GRP_ID=')+1)));
820:
821: cursor cur_retropay_asg_set is
822: select assignment_set_name
823: from hr_assignment_sets
824: where assignment_set_id = to_number(p_retropay_assignment_set)
825: and business_group_id = p_business_group_id;
826:
827: cursor cur_retropay_element_set is

Line 841: from hr_assignment_sets

837: and business_group_id = p_business_group_id;
838:
839: cursor cur_payroll_asg_set is
840: select assignment_set_name
841: from hr_assignment_sets
842: where assignment_set_id = to_number(p_payroll_assignment_set)
843: and payroll_id = l_payroll_id;
844:
845: cursor cur_payroll_run_type is

Line 963: from hr_assignment_sets

959: and enabled_flag = 'Y';
960:
961: cursor cur_roe_asg_set is
962: select assignment_set_name
963: from hr_assignment_sets
964: where assignment_set_id =
965: to_number(substr(p_roe_assignment_set,(length('ASSIGNMENT_SET_ID=')+1)));
966:
967: cursor cur_roe_worksheet_person is

Line 1018: from hr_assignment_sets

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
1018: from hr_assignment_sets
1019: where assignment_set_id = to_number(p_cost_detail_asg_set);
1020:
1021: cursor cur_costing_detail_accruals is
1022: select meaning

Line 2944: from hr_assignment_sets

2940: to_number(substr(p_retro_event_group,(length('EVT_GRP_ID=')+1)));
2941:
2942: cursor cur_retropay_asg_set is
2943: select assignment_set_name
2944: from hr_assignment_sets
2945: where assignment_set_id = to_number(p_retropay_assignment_set)
2946: and business_group_id = p_business_group_id;
2947:
2948: cursor cur_retropay_element_set is

Line 2970: from hr_assignment_sets

2966: and business_group_id = p_business_group_id;
2967:
2968: cursor cur_payroll_asg_set is
2969: select assignment_set_name
2970: from hr_assignment_sets
2971: where assignment_set_id = to_number(p_payroll_assignment_set)
2972: and payroll_id = l_payroll_id;
2973:
2974: cursor cur_payroll_run_type is

Line 3092: from hr_assignment_sets

3088: and enabled_flag = 'Y';
3089:
3090: cursor cur_roe_asg_set is
3091: select assignment_set_name
3092: from hr_assignment_sets
3093: where assignment_set_id =
3094: to_number(substr(p_roe_assignment_set,(length('ASSIGNMENT_SET_ID=')+1)));
3095:
3096: cursor cur_roe_worksheet_person is

Line 3147: from hr_assignment_sets

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
3147: from hr_assignment_sets
3148: where assignment_set_id = to_number(p_cost_detail_asg_set);
3149:
3150: cursor cur_costing_detail_accruals is
3151: select meaning