APPS.PAY_CA_T4_AMEND_MAG dependencies on PAY_ACTION_INFORMATION

Line 686: FROM pay_action_information pai,pay_payroll_actions ppa

682:
683: CURSOR c_get_reg_no(cp_pact_id IN NUMBER,
684: cp_tax_unit_id IN NUMBER) IS
685: SELECT pai.action_information4 ppreg_no
686: FROM pay_action_information pai,pay_payroll_actions ppa
687: WHERE pai.action_context_id = cp_pact_id
688: AND pai.tax_unit_id = cp_tax_unit_id
689: AND ppa.payroll_action_id = pai.action_context_id
690: AND pai.effective_date = ppa.effective_date

Line 694: lv_pp_regno1 pay_action_information.action_information4%TYPE := ' ';

690: AND pai.effective_date = ppa.effective_date
691: AND pai.action_information_category = 'CAEOY PENSION PLAN INFO'
692: ORDER BY 1 DESC;
693:
694: lv_pp_regno1 pay_action_information.action_information4%TYPE := ' ';
695: lv_pp_regno2 pay_action_information.action_information4%TYPE := ' ';
696: lv_pp_regno3 pay_action_information.action_information4%TYPE := ' ';
697: lv_pp_regno pay_action_information.action_information4%TYPE;
698:

Line 695: lv_pp_regno2 pay_action_information.action_information4%TYPE := ' ';

691: AND pai.action_information_category = 'CAEOY PENSION PLAN INFO'
692: ORDER BY 1 DESC;
693:
694: lv_pp_regno1 pay_action_information.action_information4%TYPE := ' ';
695: lv_pp_regno2 pay_action_information.action_information4%TYPE := ' ';
696: lv_pp_regno3 pay_action_information.action_information4%TYPE := ' ';
697: lv_pp_regno pay_action_information.action_information4%TYPE;
698:
699: BEGIN

Line 696: lv_pp_regno3 pay_action_information.action_information4%TYPE := ' ';

692: ORDER BY 1 DESC;
693:
694: lv_pp_regno1 pay_action_information.action_information4%TYPE := ' ';
695: lv_pp_regno2 pay_action_information.action_information4%TYPE := ' ';
696: lv_pp_regno3 pay_action_information.action_information4%TYPE := ' ';
697: lv_pp_regno pay_action_information.action_information4%TYPE;
698:
699: BEGIN
700: OPEN c_get_reg_no(p_pactid,p_tax_unit_id);

Line 697: lv_pp_regno pay_action_information.action_information4%TYPE;

693:
694: lv_pp_regno1 pay_action_information.action_information4%TYPE := ' ';
695: lv_pp_regno2 pay_action_information.action_information4%TYPE := ' ';
696: lv_pp_regno3 pay_action_information.action_information4%TYPE := ' ';
697: lv_pp_regno pay_action_information.action_information4%TYPE;
698:
699: BEGIN
700: OPEN c_get_reg_no(p_pactid,p_tax_unit_id);
701: LOOP

Line 985: lv_ppreg_no1 pay_action_information.action_information4%TYPE;

981: EOL VARCHAR2(5) := fnd_global.local_chr(13) || fnd_global.local_chr(10);
982: l_transfer_pact_id VARCHAR2(15);
983: l_transfer_tax_unit_id VARCHAR2(15);
984: l_transfer_ei_er_rate VARCHAR2(15);
985: lv_ppreg_no1 pay_action_information.action_information4%TYPE;
986: lv_ppreg_no2 pay_action_information.action_information4%TYPE;
987: lv_ppreg_no3 pay_action_information.action_information4%TYPE;
988:
989: TYPE employer_info IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;

Line 986: lv_ppreg_no2 pay_action_information.action_information4%TYPE;

982: l_transfer_pact_id VARCHAR2(15);
983: l_transfer_tax_unit_id VARCHAR2(15);
984: l_transfer_ei_er_rate VARCHAR2(15);
985: lv_ppreg_no1 pay_action_information.action_information4%TYPE;
986: lv_ppreg_no2 pay_action_information.action_information4%TYPE;
987: lv_ppreg_no3 pay_action_information.action_information4%TYPE;
988:
989: TYPE employer_info IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
990: tab_employer employer_info;

Line 987: lv_ppreg_no3 pay_action_information.action_information4%TYPE;

983: l_transfer_tax_unit_id VARCHAR2(15);
984: l_transfer_ei_er_rate VARCHAR2(15);
985: lv_ppreg_no1 pay_action_information.action_information4%TYPE;
986: lv_ppreg_no2 pay_action_information.action_information4%TYPE;
987: lv_ppreg_no3 pay_action_information.action_information4%TYPE;
988:
989: TYPE employer_info IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
990: tab_employer employer_info;
991: EIRate NUMBER :=100;