DBA Data[Home] [Help]

APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on PER_BUSINESS_GROUPS

Line 298: per_business_groups pbg

294: CURSOR get_legislation_code(cp_chk_action_id in number) is
295: SELECT pbg.legislation_code
296: FROM pay_payroll_actions ppa,
297: pay_assignment_actions paa,
298: per_business_groups pbg
299: WHERE paa.assignment_action_id = cp_chk_action_id
300: AND paa.payroll_action_id = ppa.payroll_action_id
301: AND ppa.business_group_id = pbg.business_group_id;
302:

Line 549: lv_legislation_code per_business_groups.legislation_code%TYPE ;

545: l_account_typ VARCHAR2(2000);
546: lv_action_status pay_assignment_actions.action_status%type;
547:
548: ln_chq_asg_action_id NUMBER ;
549: lv_legislation_code per_business_groups.legislation_code%TYPE ;
550: lv_full_name VARCHAR2(250);
551: l_xml BLOB;
552: ln_arch_assignment_action_id NUMBER;
553: l_proc_name varchar2(50) := 'pay_archive_chequewriter.generate_xml' ;