APPS.PAY_CA_WF_PKG dependencies on HR_ASSIGNMENT_SETS

Line 545: from hr_assignment_sets

541: to_number(substr(p_retro_event_group,(length('EVT_GRP_ID=')+1)));
542:
543: cursor cur_retropay_asg_set is
544: select assignment_set_name
545: from hr_assignment_sets
546: where assignment_set_id = to_number(p_retropay_assignment_set)
547: and business_group_id = p_business_group_id;
548:
549: cursor cur_retropay_element_set is

Line 563: from hr_assignment_sets

559: and business_group_id = p_business_group_id;
560:
561: cursor cur_payroll_asg_set is
562: select assignment_set_name
563: from hr_assignment_sets
564: where assignment_set_id = to_number(p_payroll_assignment_set)
565: and payroll_id = l_payroll_id;
566:
567: cursor cur_payroll_run_type is

Line 685: from hr_assignment_sets

681: and enabled_flag = 'Y';
682:
683: cursor cur_roe_asg_set is
684: select assignment_set_name
685: from hr_assignment_sets
686: where assignment_set_id =
687: to_number(substr(p_roe_assignment_set,(length('ASSIGNMENT_SET_ID=')+1)));
688:
689: cursor cur_roe_worksheet_person is

Line 740: from hr_assignment_sets

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
740: from hr_assignment_sets
741: where assignment_set_id = to_number(p_cost_detail_asg_set);
742:
743: cursor cur_costing_detail_accruals is
744: select meaning