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_IE_P35 dependencies on PER_ASSIGNMENTS_F

Line 113: from per_assignments_f paaf, per_assignments_f paaf1

109: l_actid pay_assignment_actions.assignment_action_id%TYPE;
110:
111: cursor csr_check_multiple_asg IS
112: select paaf.person_id
113: from per_assignments_f paaf, per_assignments_f paaf1
114: where paaf.assignment_id= p_assignment_id
115: and paaf.business_group_id = p_bg_id
116: and paaf.business_group_id =paaf1.business_group_id
117: and paaf.person_id = paaf1.person_id

Line 124: FROM per_assignments_f paf,

120: and paaf1.effective_start_date <= p_end_date;
121:
122: cursor csr_get_max_assact is
123: SELECT MAX(paa.assignment_action_id)
124: FROM per_assignments_f paf,
125: pay_assignment_actions paa,
126: pay_payroll_actions ppa,
127: per_time_periods ptp
128: WHERE paf.person_id = l_person_id

Line 248: per_assignments_f asg,

244: asg.primary_flag,
245: paa.assignment_action_id,
246: trim(rrv1.result_value) result_value
247: FROM per_people_f per,
248: per_assignments_f asg,
249: pay_assignment_actions paa,
250: pay_payroll_actions ppa,
251: per_time_periods ptp,
252: pay_run_results prr,

Line 271: FROM per_assignments_f asg2,

267: AND per2.current_employee_flag = 'Y' )
268: AND asg.person_id = per.person_id
269: AND asg.effective_start_date =
270: (SELECT MIN (asg2.effective_start_date)
271: FROM per_assignments_f asg2,
272: per_assignment_status_types ast
273: WHERE asg2.assignment_id = asg.assignment_id
274: AND asg2.effective_start_date <= p_end_date
275: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date

Line 738: per_assignments_f asg,

734: --
735: hr_utility.set_location ('End Date 3',22);
736: sqlstr := 'select distinct asg.person_id
737: from per_periods_of_service pos,
738: per_assignments_f asg,
739: pay_payroll_actions ppa
740: where ppa.payroll_action_id = :payroll_action_id
741: and pos.person_id = asg.person_id
742: and pos.period_of_service_id = asg.period_of_service_id

Line 808: FROM per_assignments_f asg,

804: asg.person_id,
805: paa.assignment_id,
806: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa -- Bug 4672715
807: ,fnd_number.canonical_to_number(substr(min(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aamin -- 8322991
808: FROM per_assignments_f asg,
809: pay_assignment_actions paa,
810: pay_payroll_actions ppa,
811: pay_all_payrolls_f pap,
812: per_time_periods ptp,

Line 837: FROM per_assignments_f paf,

833: AND asg.person_id BETWEEN stperson AND endperson
834: --decode added to pick the previous assignments also in case of ReHire having diff overrides.
835: AND asg.effective_end_date = DECODE(OVERRIDE_PPSN(asg.assignment_id),NULL, --6633719
836: (SELECT MAX (paf.effective_end_date)
837: FROM per_assignments_f paf,
838: pay_assignment_actions paa1, --Bug fix 4130665
839: pay_payroll_actions ppa1,
840: per_time_periods ptp1 --Tar 15081088.6
841: ,pay_all_payrolls_f pay

Line 875: AND (pap.payroll_id in (select b.payroll_id from per_assignments_f a,per_assignments_f b

871: -- Bug 4142582
872: AND flex.segment4 = l_segment4
873: AND pap.effective_start_date <= l_end_date
874: AND pap.effective_end_date >= l_start_date
875: AND (pap.payroll_id in (select b.payroll_id from per_assignments_f a,per_assignments_f b
876: where a.payroll_id = l_payroll_id
877: and a.person_id = b.person_id
878: and a.person_id = asg.person_id
879: --bug 6642916

Line 888: , per_assignments_f paf

884: AND ((l_assignment_set_id is not null
885: AND (l_set_flag ='I' AND EXISTS(SELECT 1
886: FROM hr_assignment_set_amendments hasa
887: , hr_assignment_sets has
888: , per_assignments_f paf
889: -- , pay_all_payrolls_f pay
890: -- , hr_soft_coding_keyflex hflex
891: WHERE has.assignment_set_id = hasa.assignment_set_id
892: AND has.business_group_id = l_bg_id

Line 902: , per_assignments_f paf

898: --AND hflex.segment4 = l_segment4)
899: OR l_set_flag = 'E' AND NOT EXISTS(SELECT 1
900: FROM hr_assignment_set_amendments hasa
901: , hr_assignment_sets has
902: , per_assignments_f paf
903: -- , pay_all_payrolls_f pay
904: -- , hr_soft_coding_keyflex hflex
905: WHERE has.assignment_set_id = hasa.assignment_set_id
906: AND has.business_group_id = l_bg_id

Line 919: per_assignments_f paaf_p35,

915: AND NOT EXISTS (
916: SELECT 1
917: FROM pay_assignment_actions paa_p35,
918: pay_payroll_actions ppa_p35,
919: per_assignments_f paaf_p35,
920: pay_all_payrolls_f ppf_p35,
921: hr_soft_coding_keyflex flex_p35,
922: pay_action_interlocks plock
923: WHERE ppa_p35.report_type = 'IEP35'

Line 1428: l_arch_person_id per_assignments_f.person_id%TYPE;

1424: l_arch_ppsn pay_action_information.action_information4%TYPE;
1425: l_arch_works_number pay_action_information.action_information14%TYPE
1426: DEFAULT ' '; --BUG 3306202 Added default value
1427: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
1428: l_arch_person_id per_assignments_f.person_id%TYPE;
1429: l_arch_assignment_id pay_assignment_actions.assignment_id%TYPE;
1430: l_arch_assmt_action_id_bal pay_assignment_actions.assignment_action_id%TYPE;
1431: l_arch_tax_deduction_basis pay_action_information.action_information17%TYPE;
1432: l_arch_surname pay_action_information.action_information29%TYPE;

Line 1482: l_asg_id per_assignments_f.assignment_id%TYPE;

1478: -- Temporary variable to hold values when Class K or M exists
1479: l_temp_prsi_cont pay_action_information.action_information4%TYPE := NULL;
1480: l_oth_arch_ovn pay_action_information.object_version_number%TYPE;
1481: l_pds_id per_periods_of_service.period_of_service_id%TYPE;
1482: l_asg_id per_assignments_f.assignment_id%TYPE;
1483: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
1484: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;
1485: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
1486: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;

Line 1486: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;

1482: l_asg_id per_assignments_f.assignment_id%TYPE;
1483: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
1484: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;
1485: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
1486: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;
1487: l_arch_asg_location_id per_assignments_f.location_id%TYPE; -- 10277535
1488: l_arch_org_id per_assignments_f.organization_id%TYPE; -- 11674153
1489: v_primary_flag per_assignments_f.primary_flag%TYPE;
1490: -- pension variables

Line 1487: l_arch_asg_location_id per_assignments_f.location_id%TYPE; -- 10277535

1483: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
1484: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;
1485: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
1486: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;
1487: l_arch_asg_location_id per_assignments_f.location_id%TYPE; -- 10277535
1488: l_arch_org_id per_assignments_f.organization_id%TYPE; -- 11674153
1489: v_primary_flag per_assignments_f.primary_flag%TYPE;
1490: -- pension variables
1491: l_arch_pen_emp_rbs pay_action_information.action_information30%TYPE;

Line 1488: l_arch_org_id per_assignments_f.organization_id%TYPE; -- 11674153

1484: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;
1485: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
1486: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;
1487: l_arch_asg_location_id per_assignments_f.location_id%TYPE; -- 10277535
1488: l_arch_org_id per_assignments_f.organization_id%TYPE; -- 11674153
1489: v_primary_flag per_assignments_f.primary_flag%TYPE;
1490: -- pension variables
1491: l_arch_pen_emp_rbs pay_action_information.action_information30%TYPE;
1492: l_arch_pen_empr_rbs pay_action_information.action_information30%TYPE;

Line 1489: v_primary_flag per_assignments_f.primary_flag%TYPE;

1485: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
1486: l_arch_primary_flag per_assignments_f.primary_flag%TYPE;
1487: l_arch_asg_location_id per_assignments_f.location_id%TYPE; -- 10277535
1488: l_arch_org_id per_assignments_f.organization_id%TYPE; -- 11674153
1489: v_primary_flag per_assignments_f.primary_flag%TYPE;
1490: -- pension variables
1491: l_arch_pen_emp_rbs pay_action_information.action_information30%TYPE;
1492: l_arch_pen_empr_rbs pay_action_information.action_information30%TYPE;
1493: l_arch_pen_emp_prsa pay_action_information.action_information30%TYPE;

Line 1768: per_assignments_f paf,

1764: --14659262
1765: FROM pay_action_information pact_edi,
1766: pay_action_information pact_iedi,
1767: pay_action_information pact_ad,
1768: per_assignments_f paf,
1769: per_periods_of_service pps,
1770: -- pay_ie_paye_details_f payef,
1771: per_time_periods ptp,
1772: per_people_f ppf

Line 1789: FROM per_assignments_f asg

1785: AND paf.assignment_id = pact_ad.assignment_id
1786: --AND paf.primary_flag = 'Y'
1787: AND paf.effective_end_date =
1788: (SELECT MAX (asg.effective_end_date)
1789: FROM per_assignments_f asg
1790: WHERE asg.assignment_id = paf.assignment_id
1791: AND asg.effective_start_date <=
1792: l_end_date --pay_ie_p35.get_start_date()
1793: AND asg.effective_end_date >=

Line 2009: per_assignments_f paf,

2005: FROM pay_action_interlocks pai,
2006: pay_assignment_actions paa,
2007: per_people_f ppf,
2008: per_periods_of_service pps,
2009: per_assignments_f paf,
2010: per_addresses pad,
2011: -- pay_ie_paye_details_f payef, --Bug 4154171
2012: pay_all_payrolls_f papf,
2013: pay_payroll_actions ppa

Line 2028: FROM per_assignments_f asg

2024: AND pad.person_id(+) = paf.person_id
2025: AND NVL (pad.primary_flag, 'Y') = 'Y'
2026: AND paf.effective_end_date =
2027: (SELECT MAX (asg.effective_end_date)
2028: FROM per_assignments_f asg
2029: WHERE asg.assignment_id = paf.assignment_id
2030: AND asg.effective_start_date <= l_end_date
2031: AND asg.effective_end_date >= l_start_date)
2032: AND ppf.effective_end_date =

Line 2246: per_assignments_f paf,

2242: --14659262
2243: FROM pay_assignment_actions paa,
2244: per_people_f ppf,
2245: per_periods_of_service pps,
2246: per_assignments_f paf,
2247: per_addresses pad,
2248: -- pay_ie_paye_details_f payef,
2249: pay_all_payrolls_f papf,
2250: pay_payroll_actions ppa

Line 2263: FROM per_assignments_f asg

2259: AND pad.person_id(+) = paf.person_id
2260: AND NVL (pad.primary_flag, 'Y') = 'Y'
2261: AND paf.effective_end_date =
2262: (SELECT MAX (asg.effective_end_date)
2263: FROM per_assignments_f asg
2264: WHERE asg.assignment_id = paf.assignment_id
2265: AND asg.effective_start_date <= l_end_date
2266: AND asg.effective_end_date >= l_start_date)
2267: AND ppf.effective_end_date =

Line 2326: FROM per_assignments_f paf,

2322: ),
2323: 0) --Bug 4111753
2324: /*( NVL(paye.weekly_tax_credit,0) +
2325: NVL(paye.Monthly_tax_credit,0)) * ptp.period_num */
2326: FROM per_assignments_f paf,
2327: per_time_periods ptp,
2328: pay_ie_paye_details_f paye
2329: WHERE paf.assignment_id = p_assignment_id
2330: AND paye.assignment_id=paf.assignment_id

Line 2402: ,per_assignments_f asg

2398: and l_end_date
2399: ORDER BY actual_termination_date desc; */
2400: SELECT max(pps.period_of_service_id)
2401: FROM per_periods_of_service pps
2402: ,per_assignments_f asg
2403: ,pay_all_payrolls_f pay
2404: ,hr_soft_coding_keyflex flex
2405: WHERE pps.person_id = v_person_id
2406: AND pps.person_id = asg.person_id

Line 2418: FROM per_assignments_f

2414: AND l_end_date;
2415:
2416: /*CURSOR c_get_terminated_asg(p_pds_id NUMBER) IS
2417: SELECT assignment_id
2418: FROM per_assignments_f
2419: WHERE period_of_service_id = p_pds_id
2420: AND primary_flag = 'Y';*/
2421:
2422: /*

Line 2429: FROM per_assignments_f

2425: FROM pay_assignment_Actions paa,
2426: pay_payroll_actions ppa
2427: -- ,per_time_periods ptp -- removed to improve performance 4771780
2428: WHERE paa.assignment_id in (SELECT assignment_id
2429: FROM per_assignments_f
2430: WHERE period_of_service_id = p_pds_id)
2431: AND paa.payroll_action_id = ppa.payroll_action_id
2432: AND ppa.action_type IN ('R','Q','I','B','V')
2433: AND paa.action_status = 'C' */

Line 2452: FROM per_assignments_f paf

2448: FROM pay_assignment_Actions paa,
2449: pay_payroll_actions ppa
2450:
2451: WHERE ( (c_ppsn is null and paa.assignment_id in (SELECT paf.assignment_id
2452: FROM per_assignments_f paf
2453: WHERE paf.period_of_service_id = p_pds_id
2454: AND paf.person_id=c_person_id))
2455: OR
2456: (c_ppsn is not null and paa.assignment_id in (SELECT paf.assignment_id

Line 2457: FROM per_assignments_f paf, per_assignment_extra_info paei

2453: WHERE paf.period_of_service_id = p_pds_id
2454: AND paf.person_id=c_person_id))
2455: OR
2456: (c_ppsn is not null and paa.assignment_id in (SELECT paf.assignment_id
2457: FROM per_assignments_f paf, per_assignment_extra_info paei
2458: WHERE paf.period_of_service_id = p_pds_id
2459: AND paf.person_id=c_person_id
2460: AND paf.assignment_id=paei.assignment_id
2461: AND paei.information_type = 'IE_ASG_OVERRIDE'

Line 2480: from per_assignments_f paf,

2476: -- for bug 5301598, increased the size to 12
2477: select NVL (SUBSTR (paf.assignment_number, 1, 12), ' '), -- WORKS NUMBER
2478: paf.primary_flag,
2479: paf.assignment_id
2480: from per_assignments_f paf,
2481: pay_assignment_actions paa
2482: where paf.assignment_id = paa.assignment_id
2483: and paa.assignment_action_id = p_action_id
2484: and paf.effective_start_date <= l_end_date

Line 2495: from per_assignments_f paf,

2491: select NVL (SUBSTR (paf.assignment_number, 1, 12), ' '), -- WORKS NUMBER
2492: paf.primary_flag,
2493: paf.assignment_id,
2494: max(effective_end_date) end_date
2495: from per_assignments_f paf,
2496: pay_assignment_actions paa
2497: where paf.assignment_id = paa.assignment_id
2498: and paa.assignment_action_id = p_action_id
2499: and paf.effective_start_date <= l_end_date

Line 2508: from per_assignments_f paf, per_assignment_extra_info paei

2504: --6633719
2505: /* Cursor to fetch primary flag for terminated assignments for PPSN OVERRIDE case*/
2506: CURSOR csr_get_primary_flag1(p_ppsn_override varchar2) is
2507: select NVL (SUBSTR (paf.assignment_number, 1, 12), ' ') -- WORKS NUMBER
2508: from per_assignments_f paf, per_assignment_extra_info paei
2509: where paf.assignment_id = paei.assignment_id
2510: and aei_information1 = p_ppsn_override
2511: and paf.effective_start_date <= l_end_date
2512: and paf.effective_end_date >= l_start_date

Line 2519: from per_assignments_f paf,

2515:
2516: /* Cursor to fetch primary flag for active assignments PPSN OVERRIDE case*/
2517: CURSOR csr_get_primary_flag_active1(p_ppsn_override varchar2) is
2518: select NVL (SUBSTR (paf.assignment_number, 1, 12), ' ') -- WORKS NUMBER
2519: from per_assignments_f paf,
2520: per_assignment_extra_info paei
2521: where paf.assignment_id = paei.assignment_id
2522: and aei_information1 = p_ppsn_override
2523: and paf.effective_start_date <= l_end_date

Line 2534: v_work_number per_assignments_f.assignment_number%TYPE;

2530:
2531: cnt number;
2532: v_action_type pay_payroll_actions.action_type%TYPE;
2533: v_report_type pay_payroll_actions.report_type%TYPE;
2534: v_work_number per_assignments_f.assignment_number%TYPE;
2535: v_assignment_id pay_assignment_actions.assignment_id%TYPE;
2536: v_action_id pay_assignment_actions.assignment_action_id%TYPE;
2537: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2538: v_chunk pay_assignment_actions.chunk_number%TYPE;

Line 2539: l_max_assignment_id per_assignments_f.assignment_id%TYPE;

2535: v_assignment_id pay_assignment_actions.assignment_id%TYPE;
2536: v_action_id pay_assignment_actions.assignment_action_id%TYPE;
2537: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2538: v_chunk pay_assignment_actions.chunk_number%TYPE;
2539: l_max_assignment_id per_assignments_f.assignment_id%TYPE;
2540: v_date date;
2541: asg_assignment_id per_assignments_f.assignment_id%TYPE;
2542: l_max_action_id pay_assignment_actions.assignment_action_id%TYPE;
2543: l_cnt number;

Line 2541: asg_assignment_id per_assignments_f.assignment_id%TYPE;

2537: v_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2538: v_chunk pay_assignment_actions.chunk_number%TYPE;
2539: l_max_assignment_id per_assignments_f.assignment_id%TYPE;
2540: v_date date;
2541: asg_assignment_id per_assignments_f.assignment_id%TYPE;
2542: l_max_action_id pay_assignment_actions.assignment_action_id%TYPE;
2543: l_cnt number;
2544: l_pl_cnt number; --8259095
2545: -- for P60 enhancement.

Line 7739: per_assignments_f paf,

7735: SELECT /*+ ORDERED USE_NL(paa, ppa, ptp)
7736: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
7737: paa.assignment_action_id),16)) assignment_action_id --bug fix 4004470
7738: FROM per_people_f ppf,
7739: per_assignments_f paf,
7740: pay_assignment_actions paa,
7741: pay_payroll_actions ppa,
7742: per_time_periods ptp
7743: WHERE

Line 7785: per_assignments_f asg,

7781: asg.primary_flag,
7782: paa.assignment_action_id,
7783: trim(rrv1.result_value) result_value
7784: FROM per_people_f per,
7785: per_assignments_f asg,
7786: pay_assignment_actions paa,
7787: pay_payroll_actions ppa,
7788: per_time_periods ptp,
7789: pay_run_results prr,

Line 7818: FROM per_assignments_f asg2,

7814: AND per2.current_employee_flag = 'Y' )
7815: AND asg.person_id = per.person_id
7816: AND asg.effective_start_date =
7817: (SELECT MIN (asg2.effective_start_date)
7818: FROM per_assignments_f asg2,
7819: per_assignment_status_types ast --Bug fix 3828506
7820: WHERE asg2.assignment_id = asg.assignment_id
7821: AND asg2.effective_start_date <= p_end_date
7822: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date

Line 7907: per_assignments_f asg,

7903: '0'
7904: )
7905: ) class_name
7906: FROM per_people_f per,
7907: per_assignments_f asg,
7908: pay_assignment_actions paa,
7909: pay_payroll_actions ppa,
7910: per_time_periods ptp,
7911: pay_run_results prr,

Line 7937: FROM per_assignments_f asg2,

7933: WHERE ast.per_system_status ='ACTIVE_ASSIGN'
7934: AND ast.assignment_status_type_id = asg.assignment_status_type_id)
7935: AND asg.effective_start_date =
7936: (SELECT MIN (asg2.effective_start_date)
7937: FROM per_assignments_f asg2,
7938: per_assignment_status_types ast --For bug fix 3828506
7939: WHERE asg2.assignment_id = asg.assignment_id
7940: AND asg2.effective_start_date <= p_end_date
7941: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date

Line 8017: per_assignments_f asg,

8013: asg.person_id per_id,
8014: MIN (ptp.end_date) min_eff_date,
8015: ptp.time_period_id
8016: FROM per_people_f per,
8017: per_assignments_f asg,
8018: pay_assignment_actions paa,
8019: pay_payroll_actions ppa,
8020: per_time_periods ptp,
8021: pay_run_results prr,

Line 8044: FROM per_assignments_f asg2,

8040: AND per2.current_employee_flag = 'Y' )
8041: AND asg.person_id = per.person_id
8042: AND asg.effective_start_date =
8043: (SELECT MIN (asg2.effective_start_date)
8044: FROM per_assignments_f asg2,
8045: per_assignment_status_types ast --Bug fix 3828506
8046: WHERE asg2.assignment_id = asg.assignment_id
8047: AND asg2.effective_start_date <= p_end_date
8048: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date

Line 8455: FROM per_assignments_f asg

8451: NVL (piw.insurable_weeks, 0)
8452: FROM pay_ie_p35_insurable_weeks_v piw
8453: WHERE piw.person_id =
8454: (SELECT asg.person_id
8455: FROM per_assignments_f asg
8456: WHERE asg.assignment_id = p_assignment_id
8457: AND asg.effective_start_date =
8458: (SELECT MIN (asg2.effective_start_date)
8459: FROM per_assignments_f asg2

Line 8459: FROM per_assignments_f asg2

8455: FROM per_assignments_f asg
8456: WHERE asg.assignment_id = p_assignment_id
8457: AND asg.effective_start_date =
8458: (SELECT MIN (asg2.effective_start_date)
8459: FROM per_assignments_f asg2
8460: WHERE asg.assignment_id =
8461: asg2.assignment_id))
8462: AND piw.insurable_weeks =
8463: (SELECT MAX (piw2.insurable_weeks)

Line 8946: p_assignment_id per_assignments_f.assignment_id%TYPE,

8942: RETURN l_end_date;
8943: END get_end_date;
8944:
8945: Function check_assignment_in_set(
8946: p_assignment_id per_assignments_f.assignment_id%TYPE,
8947: p_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE,
8948: p_business_group per_assignments_f.business_group_id%TYPE
8949: ) return NUMBER
8950: AS

Line 8948: p_business_group per_assignments_f.business_group_id%TYPE

8944:
8945: Function check_assignment_in_set(
8946: p_assignment_id per_assignments_f.assignment_id%TYPE,
8947: p_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE,
8948: p_business_group per_assignments_f.business_group_id%TYPE
8949: ) return NUMBER
8950: AS
8951: CURSOR csr_locked_asg_sets
8952: is