[Home] [Help]
763: --
764: cursor csr_scl_idsel is
765: select plr.rule_mode id_flex_num
766: from pay_legislation_rules plr,
767: per_business_groups_perf pgr
768: where plr.legislation_code = pgr.legislation_code
769: and pgr.business_group_id = p_business_group_id
770: and plr.rule_type = 'S'
771: and exists
1610: , asg.primary_flag
1611: , bus.business_group_id
1612: , bus.legislation_code
1613: from per_all_assignments_f asg
1614: , per_business_groups_perf bus
1615: where asg.assignment_id = p_assignment_id
1616: and l_actual_termination_date between asg.effective_start_date
1617: and asg.effective_end_date
1618: and bus.business_group_id+0 = asg.business_group_id;
2520: , asg.primary_flag
2521: , bus.business_group_id
2522: , bus.legislation_code
2523: from per_all_assignments_f asg
2524: , per_business_groups_perf bus
2525: where asg.assignment_id = p_assignment_id
2526: and l_actual_termination_date between asg.effective_start_date
2527: and asg.effective_end_date
2528: and bus.business_group_id+0 = asg.business_group_id;
4506: cursor csr_get_derived_details is
4507: select bus.business_group_id
4508: , bus.legislation_code
4509: from per_all_people_f per
4510: , per_business_groups_perf bus
4511: where per.person_id = p_person_id
4512: and l_effective_date between per.effective_start_date
4513: and per.effective_end_date
4514: and bus.business_group_id = per.business_group_id;
4530: -- (grp keyflex) for the specified business group
4531: --
4532: cursor csr_grp_idsel is
4533: select people_group_structure
4534: from per_business_groups_perf
4535: where business_group_id = l_business_group_id;
4536: --
4537: --
4538: -- the cursor csr_scl_idsel selects the valid id_flex_num
5933: cursor csr_get_derived_details is
5934: select bus.business_group_id
5935: , bus.legislation_code
5936: from per_all_people_f per
5937: , per_business_groups_perf bus
5938: where per.person_id = p_person_id
5939: and l_effective_date between per.effective_start_date
5940: and per.effective_end_date
5941: and bus.business_group_id = per.business_group_id;
5953: -- (grp keyflex) for the specified business group
5954: --
5955: cursor csr_grp_idsel is
5956: select people_group_structure
5957: from per_business_groups_perf
5958: where business_group_id = l_business_group_id;
5959: --
5960: --
5961: -- the cursor csr_scl_idsel selects the valid id_flex_num
7181: --
7182: cursor csr_legislation is
7183: select null
7184: from per_all_assignments_f paf,
7185: per_business_groups_perf pbg
7186: where paf.person_id = p_person_id
7187: and l_effective_date between paf.effective_start_date
7188: and paf.effective_end_date
7189: and pbg.business_group_id = paf.business_group_id
7490: --
7491: cursor csr_legislation is
7492: select null
7493: from per_all_assignments_f paf,
7494: per_business_groups_perf pbg
7495: where paf.person_id = p_person_id
7496: and l_effective_date between paf.effective_start_date
7497: and paf.effective_end_date
7498: and pbg.business_group_id = paf.business_group_id
7812: --
7813: cursor csr_legislation is
7814: select null
7815: from per_all_assignments_f paf,
7816: per_business_groups_perf pbg
7817: where paf.person_id = p_person_id
7818: and l_effective_date between paf.effective_start_date
7819: and paf.effective_end_date
7820: and pbg.business_group_id = paf.business_group_id
8145: --
8146: cursor csr_legislation is
8147: select null
8148: from per_all_assignments_f paf,
8149: per_business_groups_perf pbg
8150: where paf.person_id = p_person_id
8151: and l_effective_date between paf.effective_start_date
8152: and paf.effective_end_date
8153: and pbg.business_group_id = paf.business_group_id
10102: --
10103: cursor csr_scl_idsel is
10104: select plr.rule_mode id_flex_num
10105: from pay_legislation_rules plr,
10106: per_business_groups_perf pgr
10107: where plr.legislation_code = pgr.legislation_code
10108: and pgr.business_group_id = l_business_group_id
10109: and plr.rule_type = 'S'
10110: and exists
11341: --
11342: cursor csr_scl_idsel is
11343: select plr.rule_mode id_flex_num
11344: from pay_legislation_rules plr,
11345: per_business_groups_perf pgr
11346: where plr.legislation_code = pgr.legislation_code
11347: and pgr.business_group_id = l_business_group_id
11348: and plr.rule_type = 'CWK_S'
11349: and exists
12268: --
12269:
12270: cursor csr_get_legislation_code is
12271: select bus.legislation_code
12272: from per_business_groups_perf bus
12273: where bus.business_group_id = l_business_group_id;
12274: --
12275: cursor csr_get_salary is
12276: select element_entry_id
12281: effective_start_date and effective_end_date;
12282: --
12283: cursor csr_grp_idsel is
12284: select bus.people_group_structure
12285: from per_business_groups_perf bus
12286: where bus.business_group_id = l_business_group_id;
12287: --
12288: cursor get_sec_date_range is
12289: select asg.effective_start_date
13332: )
13333: is
13334: select bgp.legislation_code
13335: from per_all_assignments_f asg,
13336: per_business_groups_perf bgp
13337: where asg.business_group_id = bgp.business_group_id
13338: and asg.assignment_id = c_assignment_id
13339: and c_effective_date
13340: between effective_start_date and effective_end_date;
13569: )
13570: is
13571: select bgp.legislation_code
13572: from per_all_assignments_f asg,
13573: per_business_groups_perf bgp
13574: where asg.business_group_id = bgp.business_group_id
13575: and asg.assignment_id = c_assignment_id
13576: and c_effective_date
13577: between effective_start_date and effective_end_date;
14017: )
14018: is
14019: select bgp.legislation_code
14020: from per_all_assignments_f asg,
14021: per_business_groups_perf bgp
14022: where asg.business_group_id = bgp.business_group_id
14023: and asg.assignment_id = c_assignment_id
14024: and c_effective_date
14025: between effective_start_date and effective_end_date;
14283: )
14284: is
14285: select bgp.legislation_code
14286: from per_all_assignments_f asg,
14287: per_business_groups_perf bgp
14288: where asg.business_group_id = bgp.business_group_id
14289: and asg.assignment_id = c_assignment_id
14290: and c_effective_date
14291: between effective_start_date and effective_end_date;
14551: )
14552: is
14553: select bgp.legislation_code
14554: from per_all_assignments_f asg,
14555: per_business_groups_perf bgp
14556: where asg.business_group_id = bgp.business_group_id
14557: and asg.assignment_id = c_assignment_id
14558: and c_effective_date
14559: between effective_start_date and effective_end_date;
15377: where people_group_id = l_people_group_id;
15378: --
15379: cursor csr_get_legislation_code is
15380: select bus.legislation_code
15381: from per_business_groups_perf bus
15382: where bus.business_group_id = l_business_group_id;
15383: --
15384: cursor csr_get_salary is
15385: select element_entry_id
15401: -- end of fix for bug 4464072
15402: --
15403: cursor csr_grp_idsel is
15404: select bus.people_group_structure
15405: from per_business_groups_perf bus
15406: where bus.business_group_id = l_business_group_id;
15407: --
15408: cursor get_sec_date_range is
15409: select asg.effective_start_date
16844: --
16845: --
16846: cursor csr_grp_idsel is
16847: select bus.people_group_structure
16848: from per_business_groups_perf bus
16849: where bus.business_group_id = l_business_group_id;
16850: --
16851: cursor csr_scl_idsel is
16852: select plr.rule_mode id_flex_num
16850: --
16851: cursor csr_scl_idsel is
16852: select plr.rule_mode id_flex_num
16853: from pay_legislation_rules plr,
16854: per_business_groups_perf pgr
16855: where plr.legislation_code = pgr.legislation_code
16856: and pgr.business_group_id = l_business_group_id
16857: and plr.rule_type = 'S'
16858: and exists
17563: -- Added this additional check
17564: or p_scl_concat_segments <> hr_api.g_varchar2
17565: then
17566: -- gets flex num id from pay_legislation_rules and
17567: -- per_business_groups_perf
17568: --
17569: open csr_scl_idsel;
17570: fetch csr_scl_idsel into l_flex_num;
17571: --
19219: select bus.business_group_id
19220: , bus.legislation_code
19221: , per.applicant_number, per.object_version_number --3652025
19222: from per_all_people_f per
19223: , per_business_groups_perf bus
19224: where per.person_id = p_person_id
19225: and l_effective_date between per.effective_start_date
19226: and per.effective_end_date
19227: and bus.business_group_id = per.business_group_id;
19244: --
19245: --
19246: cursor csr_grp_idsel is
19247: select bus.people_group_structure
19248: from per_business_groups_perf bus
19249: where bus.business_group_id = l_business_group_id;
19250: --
19251: cursor csr_scl_idsel is
19252: select plr.rule_mode id_flex_num
19250: --
19251: cursor csr_scl_idsel is
19252: select plr.rule_mode id_flex_num
19253: from pay_legislation_rules plr,
19254: per_business_groups_perf pgr
19255: where plr.legislation_code = pgr.legislation_code
19256: and pgr.business_group_id = l_business_group_id
19257: and plr.rule_type = 'S'
19258: and exists
21526: ,bus.legislation_code
21527: ,person_id ,effective_end_date, application_id
21528: ,asg.assignment_status_type_id --7229710
21529: FROM per_all_assignments_f asg
21530: ,per_business_groups_perf bus
21531: WHERE asg.assignment_id = p_assignment_id
21532: AND bus.business_group_id = asg.business_group_id
21533: AND p_effective_date BETWEEN asg.effective_start_date
21534: AND asg.effective_end_date;