APPS.PAY_QPQ_API dependencies on PAY_LEGISLATIVE_FIELD_INFO

Line 1550: -- a) If row exists on pay_legislative_field_info with

1546: --
1547: -- Description:
1548: -- This procedure is used in update and delete validation to check the
1549: -- run type value.
1550: -- a) If row exists on pay_legislative_field_info with
1551: -- field_name = 'TAX_PROCESSING_TYPE'
1552: -- target_location = 'PAYWSRQP'
1553: -- rule_type = 'RUN_TYPE_FLAG'
1554: -- rule_mode = 'Y'

Line 1569: l_rule_mode pay_legislative_field_info.rule_mode%type;

1565: )
1566: --
1567: IS
1568: v_proc varchar2(72) := g_package||'chk_run_type';
1569: l_rule_mode pay_legislative_field_info.rule_mode%type;
1570: l_rt_exists pay_run_types_f.run_type_id%type;
1571: --
1572: cursor get_leg_rule is
1573: select lfi.rule_mode

Line 1574: from pay_legislative_field_info lfi

1570: l_rt_exists pay_run_types_f.run_type_id%type;
1571: --
1572: cursor get_leg_rule is
1573: select lfi.rule_mode
1574: from pay_legislative_field_info lfi
1575: where lfi.field_name = 'TAX_PROCESSING_TYPE'
1576: and lfi.target_location = 'PAYWSRQP'
1577: and lfi.rule_type = 'RUN_TYPE_FLAG'
1578: and lfi.validation_type = 'ITEM_PROPERTY'

Line 1591: from pay_legislative_field_info lfi

1587: and rt.business_group_id = p_business_group_id)
1588: or (rt.legislation_code is null and rt.business_group_id is null))
1589: and not exists
1590: ( select null
1591: from pay_legislative_field_info lfi
1592: where lfi.validation_type = 'EXCLUDE'
1593: and lfi.rule_type = 'DATA_VALIDATION'
1594: and lfi.field_name = 'TAX_PROCESSING_TYPE'
1595: and lfi.target_location = 'PAYWSRQP'

Line 1605: -- pay_legislative_field_info does not exist.

1601: begin
1602: hr_utility.set_location('Entering:'|| v_proc, 5);
1603: --
1604: -- Cannot have a run type id as not null if the row on
1605: -- pay_legislative_field_info does not exist.
1606: --
1607: if p_run_type_id is not null then
1608: open get_leg_rule;
1609: fetch get_leg_rule into l_rule_mode;

Line 4178: from pay_legislative_field_info

4174: v_displ_msg varchar2(30);
4175: --
4176: cursor get_leg_rule is
4177: select rule_mode
4178: from pay_legislative_field_info
4179: where legislation_code = v_leg_code
4180: and target_location = 'PAYWSRQP'
4181: and validation_type = 'DISPLAY'
4182: and rule_type = 'DISP_NTG_MSG';