APPS.PAY_QPQ_API dependencies on PAY_RUN_TYPES_F

Line 1558: -- b) Foreign key to pay_run_types_f.

1554: -- rule_mode = 'Y'
1555: -- validation_name = 'DISPLAY'
1556: -- validation_type = 'ITEM_PROPERTY'
1557: -- then tax_processing_type can be not null.
1558: -- b) Foreign key to pay_run_types_f.
1559: --
1560: Procedure chk_run_type
1561: ( p_run_type_id in pay_run_types_f.run_type_id%type
1562: ,p_effective_date in pay_payroll_actions.effective_date%TYPE

Line 1561: ( p_run_type_id in pay_run_types_f.run_type_id%type

1557: -- then tax_processing_type can be not null.
1558: -- b) Foreign key to pay_run_types_f.
1559: --
1560: Procedure chk_run_type
1561: ( p_run_type_id in pay_run_types_f.run_type_id%type
1562: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1563: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
1564: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1565: )

Line 1570: l_rt_exists pay_run_types_f.run_type_id%type;

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
1574: from pay_legislative_field_info lfi

Line 1583: from pay_run_types_f rt

1579: and lfi.validation_name = 'DISPLAY' ;
1580: --
1581: cursor get_rt_exists is
1582: select rt.run_type_id
1583: from pay_run_types_f rt
1584: where rt.run_type_id = p_run_type_id
1585: and (rt.legislation_code = p_legislation_code
1586: or (rt.legislation_code is null
1587: and rt.business_group_id = p_business_group_id)

Line 1619: -- Now check the run type is valid, i.e. exists on pay_run_types_f

1615: end if;
1616: --
1617: close get_leg_rule;
1618: --
1619: -- Now check the run type is valid, i.e. exists on pay_run_types_f
1620: -- and is either global or belongs to bix grp or leg code.
1621: --
1622: open get_rt_exists;
1623: fetch get_rt_exists into l_rt_exists;

Line 3223: -- pay_run_types_f.

3219: );
3220: hr_utility.set_location(v_proc, 13);
3221: --
3222: -- Validate the run_type - if not null, check it exists on
3223: -- pay_run_types_f.
3224: --
3225: chk_run_type
3226: (p_run_type_id => p_rec.run_type_id
3227: ,p_effective_date => p_rec.effective_date

Line 3328: -- pay_run_types_f.

3324: --
3325: -- Call business rule validation.
3326: --
3327: -- Validate the run_type - if not null, check it exists on
3328: -- pay_run_types_f.
3329: --
3330: chk_run_type
3331: (p_run_type_id => p_rec.run_type_id
3332: ,p_effective_date => p_rec.effective_date