DBA Data[Home] [Help]

APPS.PAY_DK_SOE dependencies on PER_BUSINESS_GROUPS

Line 566: , per_business_groups bg

562: , bg.legislation_code
563: , lrl.rule_mode
564: from pay_payroll_actions pa
565: , pay_assignment_actions aa
566: , per_business_groups bg
567: , pay_legislation_rules lrl
568: where aa.assignment_action_id = p_assignment_action_id
569: and aa.payroll_action_id = pa.payroll_action_id
570: and pa.business_group_id = bg.business_group_id

Line 656: , per_business_groups bg

652: CURSOR csr_get_params( p_assignment_action_id NUMBER) IS
653: SELECT '''' || bg.currency_code || '''' currency_code
654: FROM pay_payroll_actions pa
655: , pay_assignment_actions aa
656: , per_business_groups bg
657: WHERE aa.assignment_action_id = p_assignment_action_id
658: AND aa.payroll_action_id = pa.payroll_action_id
659: AND pa.business_group_id = bg.business_group_id
660: AND rownum = 1;