DBA Data[Home] [Help]

APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on PAY_LEGISLATION_RULES

Line 6419: from pay_legislation_rules plr

6415:
6416: -- Fix for Bug # 3116369
6417: cursor csr_cwk_scl_idsel(leg_code in varchar2) is
6418: select rule_mode
6419: from pay_legislation_rules plr
6420: where plr.legislation_code = leg_code
6421: and plr.rule_type = 'CWK_S'
6422: and exists
6423: (select null

Line 6432: from pay_legislation_rules plr2

6428: and fsav.segment_attribute_type = 'ASSIGNMENT'
6429: and fsav.attribute_value = 'Y')
6430: and exists
6431: (select null
6432: from pay_legislation_rules plr2
6433: where plr2.legislation_code = plr.legislation_code
6434: and plr2.rule_type = 'CWK_SDL'
6435: and plr2.rule_mode = 'A') ;
6436:

Line 6440: from pay_legislation_rules

6436:
6437:
6438: cursor csr_emp_scl_idsel(leg_code in varchar2) is
6439: select rule_mode
6440: from pay_legislation_rules
6441: where legislation_code = leg_code
6442: and rule_type = 'S'
6443: and exists
6444: (select null

Line 6453: from pay_legislation_rules

6449: and segment_attribute_type = 'ASSIGNMENT'
6450: and attribute_value = 'Y')
6451: and exists
6452: (select null
6453: from pay_legislation_rules
6454: where legislation_code = leg_code
6455: and rule_type = 'SDL'
6456: and rule_mode = 'A');
6457: --