[Home] [Help]
27: select 'x'
28: from dual
29: where exists (
30: select null
31: from per_all_assignments_f asg, per_assignment_status_types ast
32: where asg.position_id = p_position_id
33: and asg.assignment_type in ('E', 'C','A') -- changes made for the bug 5680305
34: and asg.assignment_status_type_id = ast.assignment_status_type_id
35: and ast.per_system_status <> 'TERM_ASSIGN'
120: , p_validation_end_date date) is
121: select max(pqh_psf_bus.sum_assignment_fte(p_position_id,ed))
122: from
123: (select a.effective_start_date ed
124: from per_all_assignments_f a
125: where a.position_id = p_position_id
126: and ((a.effective_start_date between p_validation_start_date and p_validation_end_date)
127: and ((a.effective_end_date between p_validation_start_date and p_validation_end_date)
128: ))
127: and ((a.effective_end_date between p_validation_start_date and p_validation_end_date)
128: ))
129: union
130: select a.effective_end_date ed
131: from per_all_assignments_f a
132: where a.position_id = p_position_id
133: and ((a.effective_start_date between p_validation_start_date and p_validation_end_date)
134: and ((a.effective_end_date between p_validation_start_date and p_validation_end_date)
135: ))
250: where position_id = p_rec.position_id;
251: --
252: cursor c_single_pos_future_asg(p_position_id number, p_effective_date date) is
253: select min(effective_start_date)
254: from per_all_assignments_f
255: where position_id = p_position_id
256: and effective_start_date > p_effective_date;
257: --
258: BEGIN
446: where assignment_id = p_rec.assignment_id;
447: --
448: cursor c_single_pos_future_asg(p_position_id number, p_effective_date date) is
449: select min(effective_start_date)
450: from per_all_assignments_f
451: where position_id = p_position_id
452: and effective_start_date > p_effective_date;
453: --
454: BEGIN
642: --
643: cursor c_changed_dates(p_position_id number,
644: p_validation_start_date date ,p_validation_end_date date) is
645: select effective_start_date, business_group_id
646: from per_all_assignments_f
647: where position_id = p_position_id
648: and effective_start_date between p_validation_start_date and p_validation_end_date
649: union
650: select effective_end_date, business_group_id
647: where position_id = p_position_id
648: and effective_start_date between p_validation_start_date and p_validation_end_date
649: union
650: select effective_end_date, business_group_id
651: from per_all_assignments_f
652: where position_id = p_position_id
653: and effective_end_date between p_validation_start_date and p_validation_end_date
654: union
655: select abv.effective_start_date, abv.business_group_id
652: where position_id = p_position_id
653: and effective_end_date between p_validation_start_date and p_validation_end_date
654: union
655: select abv.effective_start_date, abv.business_group_id
656: from per_assignment_budget_values_f abv, per_all_assignments_f asg
657: where abv.assignment_id = asg.assignment_id
658: and asg.position_id = p_position_id
659: and abv.effective_start_date between p_validation_start_date and p_validation_end_date
660: and asg.effective_start_date between p_validation_start_date and p_validation_end_date
659: and abv.effective_start_date between p_validation_start_date and p_validation_end_date
660: and asg.effective_start_date between p_validation_start_date and p_validation_end_date
661: union
662: select abv.effective_end_date, abv.business_group_id
663: from per_assignment_budget_values_f abv, per_all_assignments_f asg
664: where abv.assignment_id = asg.assignment_id
665: and asg.position_id = p_position_id
666: and abv.effective_end_date between p_validation_start_date and p_validation_end_date
667: and asg.effective_end_date between p_validation_start_date and p_validation_end_date
672: and effective_start_date between p_validation_start_date and p_validation_end_date;
673: --
674: cursor c_position_id(p_assignment_id number, p_effective_date date) is
675: select position_id
676: from per_all_assignments_f
677: where assignment_id = p_assignment_id
678: and p_effective_date between effective_start_date and effective_end_date;
679: --
680: cursor c_position_fte(p_position_id number, p_date date) is
788: l_abv_gt_fte boolean := false;
789: l_realloc number;
790: l_bgt_realloc number;
791: l_business_group_id number;
792: l_assignment_type per_all_assignments_f.assignment_type%type; -- bug 7008697
793:
794: cursor c_asg is
795: select paf.position_id, paf.person_id, paf.business_group_id, paf.assignment_type -- bug 7008697
796: from per_all_assignments_f paf
792: l_assignment_type per_all_assignments_f.assignment_type%type; -- bug 7008697
793:
794: cursor c_asg is
795: select paf.position_id, paf.person_id, paf.business_group_id, paf.assignment_type -- bug 7008697
796: from per_all_assignments_f paf
797: where paf.assignment_id = p_assignment_id
798: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
799:
800: cursor c_positions is
801: select position_id, fte, max_persons, position_type, organization_id, overlap_period
802: from hr_all_positions_f psf
803: where position_id =
804: (select position_id
805: from per_all_assignments_f paf
806: where paf.assignment_id = p_assignment_id
807: and p_effective_date between paf.effective_start_date and paf.effective_end_date)
808: and p_effective_date between psf.effective_start_date and psf.effective_end_date;
809:
808: and p_effective_date between psf.effective_start_date and psf.effective_end_date;
809:
810: cursor c_sum_abv (p_position_id number) is
811: select sum(value)
812: from per_assignment_budget_values_f abv, per_all_assignments_f asg
813: where abv.assignment_id = asg.assignment_id
814: and asg.position_id = p_position_id
815: and p_effective_date between asg.effective_start_date and asg.effective_end_date
816: and p_effective_date between abv.effective_start_date and abv.effective_end_date
950: l_abv_gt_fte boolean:=false;
951: l_realloc number;
952: l_bgt_realloc number;
953: l_business_group_id number;
954: l_assignment_type per_all_assignments_f.assignment_type%type; -- bug 7008697
955: --
956: cursor c_asg(p_assignment_id number, p_effective_date date) is
957: select position_id, person_id, business_group_id, assignment_type
958: from per_all_assignments_f paf
954: l_assignment_type per_all_assignments_f.assignment_type%type; -- bug 7008697
955: --
956: cursor c_asg(p_assignment_id number, p_effective_date date) is
957: select position_id, person_id, business_group_id, assignment_type
958: from per_all_assignments_f paf
959: where paf.assignment_id = p_assignment_id
960: and p_effective_date between paf.effective_start_date and paf.effective_end_date;
961: --
962: cursor c_positions(p_effective_date date) is
963: select position_id, fte, max_persons, position_type, organization_id, overlap_period
964: from hr_all_positions_f psf
965: where position_id =
966: (select position_id
967: from per_all_assignments_f paf
968: where paf.assignment_id = p_assignment_id
969: and p_effective_date between paf.effective_start_date and paf.effective_end_date)
970: and p_effective_date between psf.effective_start_date and psf.effective_end_date;
971:
970: and p_effective_date between psf.effective_start_date and psf.effective_end_date;
971:
972: cursor c_sum_abv (p_position_id number,p_assignment_id number, p_effective_date date) is
973: select sum(value)
974: from per_assignment_budget_values_f abv, per_all_assignments_f asg,
975: per_assignment_status_types ast
976: where abv.assignment_id = asg.assignment_id
977: and asg.position_id = p_position_id
978: and p_effective_date between asg.effective_start_date and asg.effective_end_date
1132: l_assignment_fte number(15,2):=0;
1133: --
1134: CURSOR c_budgeted_fte(p_position_id number) is
1135: select sum(nvl(value,1))
1136: from per_assignment_budget_values_f abv, per_all_assignments_f asn,
1137: per_assignment_status_types ast
1138: where abv.assignment_id(+) = asn.assignment_id
1139: and p_effective_date between asn.effective_start_date and asn.effective_end_date
1140: and p_effective_date between abv.effective_start_date and abv.effective_end_date
1174: l_assignment_fte number(15,2):=0;
1175: --
1176: CURSOR c_budgeted_fte(p_position_id number) is
1177: select sum(nvl(value,1))
1178: from per_assignment_budget_values_f abv, per_all_assignments_f asn,
1179: per_assignment_status_types ast
1180: where abv.assignment_id(+) = asn.assignment_id
1181: and asn.assignment_id <> p_assignment_id
1182: and p_effective_date between asn.effective_start_date and asn.effective_end_date
1214: l_person_id number;
1215: l_assignment_fte number(15,2):=0;
1216: CURSOR c_budgeted_fte(p_person_id number, p_position_id number) is
1217: select nvl(sum(nvl(value,1)),0)
1218: from per_all_assignments_f asn,FND_SESSIONS SS,
1219: per_assignment_budget_values_f abv, FND_SESSIONS SS2,
1220: per_assignment_status_types ast
1221: where abv.assignment_id(+) = asn.assignment_id
1222: and SS.SESSION_ID = USERENV('sessionid')
1233: and ast.per_system_status <> 'TERM_ASSIGN';
1234:
1235: CURSOR c_budgeted_fte_ex_asg(p_person_id number, p_position_id number, p_ex_assignment_id number) is
1236: select nvl(sum(nvl(value,1)),0)
1237: from per_all_assignments_f asn,FND_SESSIONS SS,
1238: per_assignment_budget_values_f abv, FND_SESSIONS SS2,
1239: per_assignment_status_types ast
1240: where abv.assignment_id(+) = asn.assignment_id
1241: and SS.SESSION_ID = USERENV('sessionid')
1304: l_assignment_fte number(15,2);
1305:
1306: CURSOR c_budgeted_fte(p_assignment_id number) is
1307: select nvl(value,1)
1308: from per_all_assignments_f asn,FND_SESSIONS SS,
1309: per_assignment_budget_values_f abv, FND_SESSIONS SS2
1310: where abv.assignment_id(+) = asn.assignment_id
1311: and SS.SESSION_ID = USERENV('sessionid')
1312: and asn.EFFECTIVE_START_DATE <= SS.EFFECTIVE_DATE
1591: between effective_start_date and effective_end_date;
1592:
1593: CURSOR C_ASSIGNMENTS IS
1594: select assignment_id
1595: from per_all_assignments_f
1596: where position_id = p_position_id
1597: and p_effective_date
1598: between effective_start_date and effective_end_date
1599: and assignment_type in ('E', 'C');
1769: select
1770: paaf.assignment_number,
1771: paaf.effective_start_date,
1772: paaf.effective_end_date
1773: from per_all_assignments_f paaf, per_assignment_status_types past
1774: where paaf.assignment_status_type_id = past.assignment_status_type_id
1775: and paaf.assignment_type in ('E','C') -- Added For Bug#14173834
1776: --and paaf.assignment_type = 'E' -- Commented For Bug#14173834
1777: and past.per_system_status <> 'TERM_ASSIGN'
1783: -- Changes start for the bug 13571263
1784:
1785: CURSOR csr_is_apl_asg IS
1786: SELECT ASSIGNMENT_TYPE
1787: FROM per_all_assignments_f
1788: WHERE assignment_id = p_assignment_id
1789: AND p_assignment_start_date between effective_start_date and effective_end_date;
1790:
1791: l_asg_type per_all_assignments_f.ASSIGNMENT_TYPE%type;
1787: FROM per_all_assignments_f
1788: WHERE assignment_id = p_assignment_id
1789: AND p_assignment_start_date between effective_start_date and effective_end_date;
1790:
1791: l_asg_type per_all_assignments_f.ASSIGNMENT_TYPE%type;
1792:
1793: -- Changes end for the bug 13571263
1794: --
1795:
1795:
1796: l_ol_effective_start_date date;
1797: l_ol_effective_end_date date;
1798:
1799: l_asg_number per_all_assignments_f.assignment_number%type;
1800: l_position_type hr_all_positions_f.position_type%type;
1801: l_asg_effective_start_date date;
1802: l_asg_effective_end_date date;
1803: -- End changes for bug 10220040
2076: --
2077: -- Cursor modified for bug 9804756
2078: cursor c1 is
2079: select count(1)
2080: from per_all_assignments_f paaf, per_assignment_status_types past
2081: where paaf.assignment_status_type_id = past.assignment_status_type_id
2082: and past.per_system_status <> 'TERM_ASSIGN'
2083: and paaf.position_id = p_position_id
2084: and paaf.assignment_type in ('E', 'C')
2219: function position_min_asg_dt(p_position_id number) return date is
2220: l_min_asg_date date;
2221: cursor c_min_asg_dt(p_position_id number) is
2222: select min(effective_start_date)
2223: from per_all_assignments_f
2224: where position_id = p_position_id
2225: and assignment_type in ('E', 'C');
2226: begin
2227: open c_min_asg_dt(p_position_id );
2233: function position_max_asg_dt(p_position_id number) return date is
2234: l_max_asg_date date;
2235: cursor c_max_asg_dt(p_position_id number) is
2236: select max(effective_start_date)
2237: from per_all_assignments_f
2238: where position_id = p_position_id
2239: and assignment_type in ('E', 'C');
2240: begin
2241: open c_max_asg_dt(p_position_id );
2412: and etp.end_date >= p_start_date
2413: and stp.start_date <= p_end_date
2414: union
2415: select effective_start_date start_date
2416: from per_all_assignments_f
2417: where p_position_id = position_id
2418: and assignment_type in ('E', 'C')
2419: and effective_start_date between p_start_date and p_end_date
2420: union
2418: and assignment_type in ('E', 'C')
2419: and effective_start_date between p_start_date and p_end_date
2420: union
2421: select abv.effective_start_date start_date
2422: from per_assignment_budget_values_f abv, per_all_assignments_f asg
2423: where abv.assignment_id = asg.assignment_id
2424: and p_position_id = asg.position_id
2425: and asg.assignment_type in ('E', 'C')
2426: and abv.unit = 'FTE'
2481: and etp.end_date >= p_start_date
2482: and stp.start_date <= p_end_date
2483: union
2484: select effective_start_date start_date
2485: from per_all_assignments_f
2486: where p_job_id = job_id
2487: and assignment_type in ('E', 'C')
2488: and effective_start_date between p_start_date and p_end_date
2489: union
2487: and assignment_type in ('E', 'C')
2488: and effective_start_date between p_start_date and p_end_date
2489: union
2490: select abv.effective_start_date start_date
2491: from per_assignment_budget_values_f abv, per_all_assignments_f asg
2492: where abv.assignment_id = asg.assignment_id
2493: and p_job_id = asg.job_id
2494: and asg.assignment_type in ('E', 'C')
2495: and abv.unit = 'FTE'
2551: and etp.end_date >= p_start_date
2552: and stp.start_date <= p_end_date
2553: union
2554: select effective_start_date start_date
2555: from per_all_assignments_f
2556: where p_organization_id = organization_id
2557: and assignment_type in ('E', 'C')
2558: and effective_start_date between p_start_date and p_end_date
2559: union
2557: and assignment_type in ('E', 'C')
2558: and effective_start_date between p_start_date and p_end_date
2559: union
2560: select abv.effective_start_date start_date
2561: from per_assignment_budget_values_f abv, per_all_assignments_f asg
2562: where abv.assignment_id = asg.assignment_id
2563: and p_organization_id = asg.organization_id
2564: and asg.assignment_type in ('E', 'C')
2565: and abv.unit = 'FTE'
2622: and etp.end_date >= p_start_date
2623: and stp.start_date <= p_end_date
2624: union
2625: select effective_start_date start_date
2626: from per_all_assignments_f
2627: where p_grade_id = grade_id
2628: and assignment_type in ('E', 'C')
2629: and effective_start_date between p_start_date and p_end_date
2630: union
2628: and assignment_type in ('E', 'C')
2629: and effective_start_date between p_start_date and p_end_date
2630: union
2631: select abv.effective_start_date start_date
2632: from per_assignment_budget_values_f abv, per_all_assignments_f asg
2633: where abv.assignment_id = asg.assignment_id
2634: and p_grade_id = asg.grade_id
2635: and asg.assignment_type in ('E', 'C')
2636: and abv.unit = 'FTE'
3009: function assignment_fte(p_assignment_id number, p_effective_date date) return number is
3010: l_fte number := 0;
3011: cursor c1(p_assignment_id number, p_effective_date date) is
3012: select nvl(abv.value,0)
3013: from per_assignment_budget_values_f abv, per_all_assignments_f asg,
3014: per_assignment_status_types ast
3015: where asg.assignment_id = p_assignment_id
3016: and abv.assignment_id = asg.assignment_id
3017: and asg.assignment_type in ('E', 'C')
3305: l_business_group_id number;
3306: --
3307: cursor c_bus_grp_id(p_assignment_id number) is
3308: select business_group_id
3309: from per_all_assignments_f
3310: where assignment_id = p_assignment_id
3311: and p_effective_date between effective_start_date and effective_end_date;
3312: --
3313: cursor c1(p_unit_id number) is select system_type_cd from
3528: --
3529: cursor c1(p_position_id number, p_effective_date date,
3530: p_ex_position_extra_info_id number, p_ex_person_id number) is
3531: select sum(nvl(value,0))
3532: from per_all_assignments_f asn,
3533: per_assignment_budget_values_f abv,
3534: per_assignment_status_types ast
3535: where abv.assignment_id = asn.assignment_id
3536: and asn.EFFECTIVE_START_DATE <= p_effective_date
3589: l_person_id number;
3590: l_assignment_fte number(15,2):=0;
3591: CURSOR c_budgeted_fte(p_person_id number, p_position_id number) is
3592: select nvl(sum(nvl(value,1)),0)
3593: from per_assignment_budget_values_f abv, per_all_assignments_f asn,
3594: per_assignment_status_types ast
3595: where abv.assignment_id(+) = asn.assignment_id
3596: and asn.position_id = p_position_id
3597: and asn.person_id = p_person_id
3630: --
3631: cursor c1(p_position_id number, p_position_extra_info_id number,
3632: p_start_date date, p_end_date date) is
3633: select abv.effective_start_date effective_date
3634: from per_assignment_budget_values_f abv, per_all_assignments_f asn
3635: where abv.assignment_id = asn.assignment_id
3636: and asn.position_id = p_position_id
3637: and abv.effective_start_date between asn.effective_start_date and asn.effective_end_date
3638: and abv.effective_start_date between
3642: and asn.assignment_type in ('E', 'C')
3643: and abv.unit(+) = 'FTE'
3644: union
3645: select effective_start_date effective_date
3646: from per_all_assignments_f asg
3647: where position_id = p_position_id
3648: and asg.effective_start_date between
3649: p_start_date and nvl(p_end_date, hr_general.end_of_time)
3650: union
3894: l_available_fte number;
3895: l_assignment_fte number;
3896: cursor c1(p_assignment_id number, p_position_id number, p_validation_start_date date, p_validation_end_date date) is
3897: select effective_start_date
3898: from per_all_assignments_f
3899: where position_id = p_position_id
3900: and assignment_type in ('E', 'C')
3901: and effective_start_date between p_validation_start_date and p_validation_end_date
3902: union
3900: and assignment_type in ('E', 'C')
3901: and effective_start_date between p_validation_start_date and p_validation_end_date
3902: union
3903: select abv.effective_start_date effective_start_date
3904: from per_assignment_budget_values_f abv, per_all_assignments_f asg
3905: where abv.assignment_id = asg.assignment_id
3906: and asg.position_id = p_position_id
3907: and asg.assignment_type in ('E', 'C')
3908: and abv.effective_start_date between asg.effective_start_date and asg.effective_end_date
3916: and information_type = 'PER_RESERVED')
3917: where effective_start_date >= p_validation_start_date
3918: union
3919: select effective_start_date
3920: from per_all_assignments_f
3921: where assignment_id = p_assignment_id
3922: and assignment_type in ('E', 'C')
3923: and effective_start_date between p_validation_start_date and p_validation_end_date
3924: union
3922: and assignment_type in ('E', 'C')
3923: and effective_start_date between p_validation_start_date and p_validation_end_date
3924: union
3925: select abv.effective_start_date effective_start_date
3926: from per_assignment_budget_values_f abv, per_all_assignments_f asg
3927: where abv.assignment_id = asg.assignment_id
3928: and asg.assignment_id = p_assignment_id
3929: and asg.assignment_type in ('E', 'C')
3930: and abv.effective_start_date between asg.effective_start_date and asg.effective_end_date
3936: and effective_start_date between p_validation_start_date and p_validation_end_date;
3937: --
3938: cursor c2(p_position_id number, p_validation_start_date date, p_validation_end_date date) is
3939: select effective_start_date
3940: from per_all_assignments_f
3941: where position_id = p_position_id
3942: and assignment_type in ('E', 'C')
3943: and effective_start_date between p_validation_start_date and p_validation_end_date
3944: union
3942: and assignment_type in ('E', 'C')
3943: and effective_start_date between p_validation_start_date and p_validation_end_date
3944: union
3945: select abv.effective_start_date effective_start_date
3946: from per_assignment_budget_values_f abv, per_all_assignments_f asg
3947: where abv.assignment_id = asg.assignment_id
3948: and asg.position_id = p_position_id
3949: and asg.assignment_type in ('E', 'C')
3950: and abv.effective_start_date between asg.effective_start_date and asg.effective_end_date
4164: l_total_asg_fte number;
4165: --
4166: cursor c1(p_assignment_id number, p_position_id number, p_validation_start_date date, p_validation_end_date date) is
4167: select effective_start_date
4168: from per_all_assignments_f
4169: where position_id = p_position_id
4170: and assignment_type in ('E', 'C')
4171: and effective_start_date between p_validation_start_date and p_validation_end_date
4172: and effective_end_date between p_validation_start_date and p_validation_end_date -- 11059779
4172: and effective_end_date between p_validation_start_date and p_validation_end_date -- 11059779
4173: union
4174: --11059779
4175: select effective_end_date --effective_start_date changed for bug 12751673
4176: from per_all_assignments_f
4177: where position_id = p_position_id
4178: and assignment_type in ('E', 'C')
4179: and( p_validation_start_date between effective_start_date and effective_end_date
4180: or p_validation_end_date between effective_start_date and effective_end_date)
4180: or p_validation_end_date between effective_start_date and effective_end_date)
4181: --11059779
4182: union
4183: select abv.effective_start_date effective_start_date
4184: from per_assignment_budget_values_f abv, per_all_assignments_f asg
4185: where abv.assignment_id = asg.assignment_id
4186: and asg.position_id = p_position_id
4187: and asg.assignment_type in ('E', 'C')
4188: and abv.effective_start_date between asg.effective_start_date and asg.effective_end_date
4189: and asg.effective_start_date between p_validation_start_date and p_validation_end_date
4190: and asg.business_group_id = abv.business_group_id
4191: union
4192: select effective_start_date
4193: from per_all_assignments_f
4194: where assignment_id = p_assignment_id
4195: and assignment_type in ('E', 'C')
4196: and effective_start_date between p_validation_start_date and p_validation_end_date
4197: union
4195: and assignment_type in ('E', 'C')
4196: and effective_start_date between p_validation_start_date and p_validation_end_date
4197: union
4198: select abv.effective_start_date effective_start_date
4199: from per_assignment_budget_values_f abv, per_all_assignments_f asg
4200: where abv.assignment_id = asg.assignment_id
4201: and asg.assignment_id = p_assignment_id
4202: and asg.assignment_type in ('E', 'C')
4203: and abv.effective_start_date between asg.effective_start_date and asg.effective_end_date
4209: and effective_start_date between p_validation_start_date and p_validation_end_date;
4210: --
4211: cursor c2(p_position_id number, p_validation_start_date date, p_validation_end_date date) is
4212: select effective_start_date
4213: from per_all_assignments_f
4214: where position_id = p_position_id
4215: and assignment_type in ('E', 'C')
4216: and effective_start_date between p_validation_start_date and p_validation_end_date
4217: union
4215: and assignment_type in ('E', 'C')
4216: and effective_start_date between p_validation_start_date and p_validation_end_date
4217: union
4218: select abv.effective_start_date effective_start_date
4219: from per_assignment_budget_values_f abv, per_all_assignments_f asg
4220: where abv.assignment_id = asg.assignment_id
4221: and asg.position_id = p_position_id
4222: and asg.assignment_type in ('E', 'C')
4223: and abv.effective_start_date between asg.effective_start_date and asg.effective_end_date
4493: --
4494: --
4495: CURSOR c_sum_asg_fte(p_position_id number) is
4496: select sum(value)
4497: from per_assignment_budget_values_f abv, per_all_assignments_f asn,
4498: per_assignment_status_types ast
4499: where abv.assignment_id(+) = asn.assignment_id
4500: and p_effective_start_date between asn.effective_start_date and asn.effective_end_date
4501: and p_effective_start_date between abv.effective_start_date and abv.effective_end_date
4634:
4635: --
4636: cursor c_assignment(p_assignment_id number, p_effective_date date) is
4637: select position_id, organization_id
4638: from per_all_assignments_f
4639: where assignment_id = p_assignment_id
4640: and p_effective_date between effective_start_date and effective_end_date;
4641: --
4642: begin
4739: --
4740: cursor c_pay_basis_info(p_assignment_id number,
4741: p_effective_date date) is
4742: select piv.element_type_id, ppb.input_value_id
4743: from per_all_assignments_f asg,
4744: per_pay_bases ppb,
4745: pay_input_values_f piv
4746: where assignment_id = p_assignment_id
4747: and asg.pay_basis_id = ppb.pay_basis_id