DBA Data[Home] [Help]

APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on PAY_LEGISLATION_RULES

Line 6749: from pay_legislation_rules plr

6745:
6746: -- Fix for Bug # 3116369
6747: cursor csr_cwk_scl_idsel(leg_code in varchar2) is
6748: select rule_mode
6749: from pay_legislation_rules plr
6750: where plr.legislation_code = leg_code
6751: and plr.rule_type = 'CWK_S'
6752: and exists
6753: (select null

Line 6762: from pay_legislation_rules plr2

6758: and fsav.segment_attribute_type = 'ASSIGNMENT'
6759: and fsav.attribute_value = 'Y')
6760: and exists
6761: (select null
6762: from pay_legislation_rules plr2
6763: where plr2.legislation_code = plr.legislation_code
6764: and plr2.rule_type = 'CWK_SDL'
6765: and plr2.rule_mode = 'A') ;
6766:

Line 6770: from pay_legislation_rules

6766:
6767:
6768: cursor csr_emp_scl_idsel(leg_code in varchar2) is
6769: select rule_mode
6770: from pay_legislation_rules
6771: where legislation_code = leg_code
6772: and rule_type = 'S'
6773: and exists
6774: (select null

Line 6783: from pay_legislation_rules

6779: and segment_attribute_type = 'ASSIGNMENT'
6780: and attribute_value = 'Y')
6781: and exists
6782: (select null
6783: from pay_legislation_rules
6784: where legislation_code = leg_code
6785: and rule_type = 'SDL'
6786: and rule_mode = 'A');
6787: