DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_F2_PKG dependencies on PAY_LEGISLATION_RULES

Line 347: from pay_legislation_rules

343: -- order by table_name desc;
344: --
345: cursor scl is
346: select rule_mode
347: from pay_legislation_rules
348: where legislation_code = P_LEG_CODE
349: and rule_type = 'S'
350: and exists
351: (select null

Line 360: from pay_legislation_rules

356: and segment_attribute_type = 'ASSIGNMENT'
357: and attribute_value = 'Y')
358: and exists
359: (select null
360: from pay_legislation_rules
361: where legislation_code = P_LEG_CODE
362: and rule_type = 'SDL'
363: and rule_mode = 'A') ;
364:

Line 367: from pay_legislation_rules

363: and rule_mode = 'A') ;
364:
365: cursor scl_cwk is
366: select rule_mode
367: from pay_legislation_rules
368: where legislation_code = P_LEG_CODE
369: and rule_type = 'CWK_S'
370: and exists
371: (select null

Line 380: from pay_legislation_rules

376: and segment_attribute_type = 'ASSIGNMENT'
377: and attribute_value = 'Y')
378: and exists
379: (select null
380: from pay_legislation_rules
381: where legislation_code = P_LEG_CODE
382: and rule_type = 'CWK_SDL'
383: and rule_mode = 'A');
384: