APPS.PER_CA_EE_EXTRACT_PKG dependencies on PAY_CA_LEGISLATION_INFO

Line 821: pay_ca_legislation_info pcli

817: cursor cur_legislation_info(p_lookup_type varchar2) is
818: select
819: pcli.lookup_code
820: from
821: pay_ca_legislation_info pcli
822: where
823: pcli.lookup_type = p_lookup_type;
824:
825: v_legislation_info pay_ca_legislation_info.lookup_code%TYPE;

Line 825: v_legislation_info pay_ca_legislation_info.lookup_code%TYPE;

821: pay_ca_legislation_info pcli
822: where
823: pcli.lookup_type = p_lookup_type;
824:
825: v_legislation_info pay_ca_legislation_info.lookup_code%TYPE;
826: v_print varchar2(1);
827:
828: cursor cur_gre_id(p_naic varchar2) is
829: select hou.organization_id

Line 1132: from pay_ca_legislation_info

1128: declare
1129:
1130: cursor cur_legislation_info(p_lookup_type varchar2) is
1131: select lookup_code
1132: from pay_ca_legislation_info
1133: where lookup_type = p_lookup_type;
1134:
1135: v_leg_info pay_ca_legislation_info.lookup_code%TYPE;
1136:

Line 1135: v_leg_info pay_ca_legislation_info.lookup_code%TYPE;

1131: select lookup_code
1132: from pay_ca_legislation_info
1133: where lookup_type = p_lookup_type;
1134:
1135: v_leg_info pay_ca_legislation_info.lookup_code%TYPE;
1136:
1137: cursor cur_naic is
1138: select
1139: pert.segment3 tot_number_emp,

Line 2131: from pay_ca_legislation_info

2127: declare
2128:
2129: cursor cur_legislation_info(p_lookup_type varchar2) is
2130: select lookup_code
2131: from pay_ca_legislation_info
2132: where lookup_type = p_lookup_type;
2133:
2134: v_leg_info pay_ca_legislation_info.lookup_code%TYPE;
2135:

Line 2134: v_leg_info pay_ca_legislation_info.lookup_code%TYPE;

2130: select lookup_code
2131: from pay_ca_legislation_info
2132: where lookup_type = p_lookup_type;
2133:
2134: v_leg_info pay_ca_legislation_info.lookup_code%TYPE;
2135:
2136: cursor cur_naic is
2137: select
2138: pert.segment3 tot_number_emp,

Line 8853: from pay_ca_legislation_info

8849: from
8850: per_ca_ee_report_lines
8851: where request_id = p_request_id
8852: and to_number(segment3) < (select to_number(lookup_code)
8853: from pay_ca_legislation_info
8854: where lookup_type = 'EER1')
8855: and context = 'FORM12' and
8856: segment4 <> v_max_naic_code;
8857: