APPS.HR_ASSIGNMENT_API dependencies on PAY_LEGISLATION_RULES

Line 1327: from pay_legislation_rules plr,

1323:
1324: --
1325: cursor csr_scl_idsel is
1326: select plr.rule_mode id_flex_num
1327: from pay_legislation_rules plr,
1328: per_business_groups_perf pgr
1329: where plr.legislation_code = pgr.legislation_code
1330: and pgr.business_group_id = p_business_group_id
1331: and plr.rule_type = 'S'

Line 1342: from pay_legislation_rules plr2

1338: and fsav.segment_attribute_type = 'ASSIGNMENT'
1339: and fsav.attribute_value = 'Y')
1340: and exists
1341: (select 1
1342: from pay_legislation_rules plr2
1343: where plr2.legislation_code = plr.legislation_code
1344: and plr2.rule_type = 'SDL'
1345: and plr2.rule_mode = 'A') ;
1346: --

Line 5110: from pay_legislation_rules plr

5106: -- (scl keyflex) for the specified business group
5107: --
5108: cursor csr_scl_idsel is
5109: select plr.rule_mode id_flex_num
5110: from pay_legislation_rules plr
5111: where plr.legislation_code = l_legislation_code
5112: and plr.rule_type = 'S'
5113: and exists
5114: (select 1

Line 5123: from pay_legislation_rules plr2

5119: and fsav.segment_attribute_type = 'ASSIGNMENT'
5120: and fsav.attribute_value = 'Y')
5121: and exists
5122: (select 1
5123: from pay_legislation_rules plr2
5124: where plr2.legislation_code = l_legislation_code
5125: and plr2.rule_type = 'SDL'
5126: and plr2.rule_mode = 'A') ;
5127: --

Line 6533: from pay_legislation_rules plr

6529: -- (scl keyflex) for the specified business group
6530: --
6531: cursor csr_scl_idsel is
6532: select plr.rule_mode id_flex_num
6533: from pay_legislation_rules plr
6534: where plr.legislation_code = l_legislation_code
6535: and plr.rule_type = 'S'
6536: and exists
6537: (select 1

Line 6546: from pay_legislation_rules plr2

6542: and fsav.segment_attribute_type = 'ASSIGNMENT'
6543: and fsav.attribute_value = 'Y')
6544: and exists
6545: (select 1
6546: from pay_legislation_rules plr2
6547: where plr2.legislation_code = l_legislation_code
6548: and plr2.rule_type = 'SDL'
6549: and plr2.rule_mode = 'A') ;
6550: --

Line 10672: from pay_legislation_rules plr,

10668: and asg.effective_end_date;
10669: --
10670: cursor csr_scl_idsel is
10671: select plr.rule_mode id_flex_num
10672: from pay_legislation_rules plr,
10673: per_business_groups_perf pgr
10674: where plr.legislation_code = pgr.legislation_code
10675: and pgr.business_group_id = l_business_group_id
10676: and plr.rule_type = 'S'

Line 10687: from pay_legislation_rules plr2

10683: and fsav.segment_attribute_type = 'ASSIGNMENT'
10684: and fsav.attribute_value = 'Y')
10685: and exists
10686: (select 1
10687: from pay_legislation_rules plr2
10688: where plr2.legislation_code = plr.legislation_code
10689: and plr2.rule_type = 'SDL'
10690: and plr2.rule_mode = 'A') ;
10691: --

Line 11945: from pay_legislation_rules plr,

11941: and asg.effective_end_date;
11942: --
11943: cursor csr_scl_idsel is
11944: select plr.rule_mode id_flex_num
11945: from pay_legislation_rules plr,
11946: per_business_groups_perf pgr
11947: where plr.legislation_code = pgr.legislation_code
11948: and pgr.business_group_id = l_business_group_id
11949: and plr.rule_type = 'CWK_S'

Line 11960: from pay_legislation_rules plr2

11956: and fsav.segment_attribute_type = 'ASSIGNMENT'
11957: and fsav.attribute_value = 'Y')
11958: and exists
11959: (select 1
11960: from pay_legislation_rules plr2
11961: where plr2.legislation_code = plr.legislation_code
11962: and plr2.rule_type = 'CWK_SDL'
11963: and plr2.rule_mode = 'A') ;
11964:

Line 17699: from pay_legislation_rules plr,

17695: where bus.business_group_id = l_business_group_id;
17696: --
17697: cursor csr_scl_idsel is
17698: select plr.rule_mode id_flex_num
17699: from pay_legislation_rules plr,
17700: per_business_groups_perf pgr
17701: where plr.legislation_code = pgr.legislation_code
17702: and pgr.business_group_id = l_business_group_id
17703: and plr.rule_type = 'S'

Line 17714: from pay_legislation_rules plr2

17710: and fsav.segment_attribute_type = 'ASSIGNMENT'
17711: and fsav.attribute_value = 'Y')
17712: and exists
17713: (select 1
17714: from pay_legislation_rules plr2
17715: where plr2.legislation_code = plr.legislation_code
17716: and plr2.rule_type = 'SDL'
17717: and plr2.rule_mode = 'A') ;
17718: --

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

18409: -- Bug 944911
18410: -- Added this additional check
18411: or p_scl_concat_segments <> hr_api.g_varchar2
18412: then
18413: -- gets flex num id from pay_legislation_rules and
18414: -- per_business_groups_perf
18415: --
18416: open csr_scl_idsel;
18417: fetch csr_scl_idsel into l_flex_num;

Line 20116: from pay_legislation_rules plr,

20112: where bus.business_group_id = l_business_group_id;
20113: --
20114: cursor csr_scl_idsel is
20115: select plr.rule_mode id_flex_num
20116: from pay_legislation_rules plr,
20117: per_business_groups_perf pgr
20118: where plr.legislation_code = pgr.legislation_code
20119: and pgr.business_group_id = l_business_group_id
20120: and plr.rule_type = 'S'

Line 20131: from pay_legislation_rules plr2

20127: and fsav.segment_attribute_type = 'ASSIGNMENT'
20128: and fsav.attribute_value = 'Y')
20129: and exists
20130: (select 1
20131: from pay_legislation_rules plr2
20132: where plr2.legislation_code = plr.legislation_code
20133: and plr2.rule_type = 'SDL'
20134: and plr2.rule_mode = 'A') ;
20135: --