APPS.HR_ASSIGNMENT_API dependencies on PAY_LEGISLATION_RULES

Line 766: from pay_legislation_rules plr,

762:
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'

Line 781: from pay_legislation_rules plr2

777: and fsav.segment_attribute_type = 'ASSIGNMENT'
778: and fsav.attribute_value = 'Y')
779: and exists
780: (select 1
781: from pay_legislation_rules plr2
782: where plr2.legislation_code = plr.legislation_code
783: and plr2.rule_type = 'SDL'
784: and plr2.rule_mode = 'A') ;
785: --

Line 4543: from pay_legislation_rules plr

4539: -- (scl keyflex) for the specified business group
4540: --
4541: cursor csr_scl_idsel is
4542: select plr.rule_mode id_flex_num
4543: from pay_legislation_rules plr
4544: where plr.legislation_code = l_legislation_code
4545: and plr.rule_type = 'S'
4546: and exists
4547: (select 1

Line 4556: from pay_legislation_rules plr2

4552: and fsav.segment_attribute_type = 'ASSIGNMENT'
4553: and fsav.attribute_value = 'Y')
4554: and exists
4555: (select 1
4556: from pay_legislation_rules plr2
4557: where plr2.legislation_code = l_legislation_code
4558: and plr2.rule_type = 'SDL'
4559: and plr2.rule_mode = 'A') ;
4560: --

Line 5966: from pay_legislation_rules plr

5962: -- (scl keyflex) for the specified business group
5963: --
5964: cursor csr_scl_idsel is
5965: select plr.rule_mode id_flex_num
5966: from pay_legislation_rules plr
5967: where plr.legislation_code = l_legislation_code
5968: and plr.rule_type = 'S'
5969: and exists
5970: (select 1

Line 5979: from pay_legislation_rules plr2

5975: and fsav.segment_attribute_type = 'ASSIGNMENT'
5976: and fsav.attribute_value = 'Y')
5977: and exists
5978: (select 1
5979: from pay_legislation_rules plr2
5980: where plr2.legislation_code = l_legislation_code
5981: and plr2.rule_type = 'SDL'
5982: and plr2.rule_mode = 'A') ;
5983: --

Line 10105: from pay_legislation_rules plr,

10101: and asg.effective_end_date;
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'

Line 10120: from pay_legislation_rules plr2

10116: and fsav.segment_attribute_type = 'ASSIGNMENT'
10117: and fsav.attribute_value = 'Y')
10118: and exists
10119: (select 1
10120: from pay_legislation_rules plr2
10121: where plr2.legislation_code = plr.legislation_code
10122: and plr2.rule_type = 'SDL'
10123: and plr2.rule_mode = 'A') ;
10124: --

Line 11344: from pay_legislation_rules plr,

11340: and asg.effective_end_date;
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'

Line 11359: from pay_legislation_rules plr2

11355: and fsav.segment_attribute_type = 'ASSIGNMENT'
11356: and fsav.attribute_value = 'Y')
11357: and exists
11358: (select 1
11359: from pay_legislation_rules plr2
11360: where plr2.legislation_code = plr.legislation_code
11361: and plr2.rule_type = 'CWK_SDL'
11362: and plr2.rule_mode = 'A') ;
11363:

Line 16853: from pay_legislation_rules plr,

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
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'

Line 16868: from pay_legislation_rules plr2

16864: and fsav.segment_attribute_type = 'ASSIGNMENT'
16865: and fsav.attribute_value = 'Y')
16866: and exists
16867: (select 1
16868: from pay_legislation_rules plr2
16869: where plr2.legislation_code = plr.legislation_code
16870: and plr2.rule_type = 'SDL'
16871: and plr2.rule_mode = 'A') ;
16872: --

Line 17566: -- gets flex num id from pay_legislation_rules and

17562: -- Bug 944911
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;

Line 19253: from pay_legislation_rules plr,

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
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'

Line 19268: from pay_legislation_rules plr2

19264: and fsav.segment_attribute_type = 'ASSIGNMENT'
19265: and fsav.attribute_value = 'Y')
19266: and exists
19267: (select 1
19268: from pay_legislation_rules plr2
19269: where plr2.legislation_code = plr.legislation_code
19270: and plr2.rule_type = 'SDL'
19271: and plr2.rule_mode = 'A') ;
19272: --