APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on PER_BUSINESS_GROUPS

Line 248: ,p_legislation_code IN per_business_groups.legislation_code%TYPE)

244: ,cp_employee_no IN VARCHAR2
245: ,cp_full_name IN VARCHAR2
246: ,cp_national_identifier IN VARCHAR2
247: ,p_xml_dummy_tab OUT NOCOPY pay_archive_chequewriter.ltr_char_tab_typ
248: ,p_legislation_code IN per_business_groups.legislation_code%TYPE)
249: AS
250: CURSOR get_flex_segment(cp_flex_ctx_code IN VARCHAR2)
251: IS
252: SELECT end_user_column_name

Line 373: per_business_groups pbg

369: CURSOR get_legislation_code(cp_chk_action_id in number) is
370: SELECT pbg.legislation_code
371: FROM pay_payroll_actions ppa,
372: pay_assignment_actions paa,
373: per_business_groups pbg
374: WHERE paa.assignment_action_id = cp_chk_action_id
375: AND paa.payroll_action_id = ppa.payroll_action_id
376: AND ppa.business_group_id = pbg.business_group_id;
377:

Line 740: lv_legislation_code per_business_groups.legislation_code%TYPE ;

736: l_account_typ VARCHAR2(2000);
737: lv_action_status pay_assignment_actions.action_status%type;
738:
739: ln_chq_asg_action_id NUMBER ;
740: lv_legislation_code per_business_groups.legislation_code%TYPE ;
741: lv_full_name VARCHAR2(250);
742: l_xml BLOB;
743: ln_arch_assignment_action_id NUMBER;
744: l_proc_name varchar2(50) := 'pay_archive_chequewriter.generate_xml' ;