DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PAY_LEGISLATIVE_FIELD_INFO

Line 131: from pay_legislative_field_info plfi

127: where benfts_grp_id=p_benfts_grp_id;
128: --
129: cursor leg_lookup(p_type varchar2) is
130: select rule_type
131: from pay_legislative_field_info plfi
132: where plfi.field_name = p_type
133: and plfi.legislation_code = p_legislation_code;
134: --
135: l_rule_type pay_legislative_field_info.rule_type%type;

Line 135: l_rule_type pay_legislative_field_info.rule_type%type;

131: from pay_legislative_field_info plfi
132: where plfi.field_name = p_type
133: and plfi.legislation_code = p_legislation_code;
134: --
135: l_rule_type pay_legislative_field_info.rule_type%type;
136: --
137: cursor csr_application
138: (p_person_id number
139: ,p_effective_date date) is