DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PAY_LEGISLATIVE_FIELD_INFO

Line 160: from pay_legislative_field_info plfi

156: where benfts_grp_id=p_benfts_grp_id;
157: --
158: cursor leg_lookup(p_type varchar2) is
159: select rule_type
160: from pay_legislative_field_info plfi
161: where plfi.field_name = p_type
162: and plfi.legislation_code = p_legislation_code;
163: --
164: l_rule_type pay_legislative_field_info.rule_type%type;

Line 164: l_rule_type pay_legislative_field_info.rule_type%type;

160: from pay_legislative_field_info plfi
161: where plfi.field_name = p_type
162: and plfi.legislation_code = p_legislation_code;
163: --
164: l_rule_type pay_legislative_field_info.rule_type%type;
165: --
166: cursor csr_application
167: (p_person_id number
168: ,p_effective_date date) is