APPS.PAY_QPQ_API dependencies on PAY_RUN_TYPES_F

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

1573: -- rule_mode = 'Y'
1574: -- validation_name = 'DISPLAY'
1575: -- validation_type = 'ITEM_PROPERTY'
1576: -- then tax_processing_type can be not null.
1577: -- b) Foreign key to pay_run_types_f.
1578: --
1579: Procedure chk_run_type
1580: ( p_run_type_id in pay_run_types_f.run_type_id%type
1581: ,p_effective_date in pay_payroll_actions.effective_date%TYPE

Line 1580: ( p_run_type_id in pay_run_types_f.run_type_id%type

1576: -- then tax_processing_type can be not null.
1577: -- b) Foreign key to pay_run_types_f.
1578: --
1579: Procedure chk_run_type
1580: ( p_run_type_id in pay_run_types_f.run_type_id%type
1581: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1582: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
1583: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1584: )

Line 1589: l_rt_exists pay_run_types_f.run_type_id%type;

1585: --
1586: IS
1587: v_proc varchar2(72) := g_package||'chk_run_type';
1588: l_rule_mode pay_legislative_field_info.rule_mode%type;
1589: l_rt_exists pay_run_types_f.run_type_id%type;
1590: --
1591: cursor get_leg_rule is
1592: select lfi.rule_mode
1593: from pay_legislative_field_info lfi

Line 1602: from pay_run_types_f rt

1598: and lfi.validation_name = 'DISPLAY' ;
1599: --
1600: cursor get_rt_exists is
1601: select rt.run_type_id
1602: from pay_run_types_f rt
1603: where rt.run_type_id = p_run_type_id
1604: and (rt.legislation_code = p_legislation_code
1605: or (rt.legislation_code is null
1606: and rt.business_group_id = p_business_group_id)

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

1634: end if;
1635: --
1636: close get_leg_rule;
1637: --
1638: -- Now check the run type is valid, i.e. exists on pay_run_types_f
1639: -- and is either global or belongs to bix grp or leg code.
1640: --
1641: open get_rt_exists;
1642: fetch get_rt_exists into l_rt_exists;

Line 3245: -- pay_run_types_f.

3241: );
3242: hr_utility.set_location(v_proc, 13);
3243: --
3244: -- Validate the run_type - if not null, check it exists on
3245: -- pay_run_types_f.
3246: --
3247: chk_run_type
3248: (p_run_type_id => p_rec.run_type_id
3249: ,p_effective_date => p_rec.effective_date

Line 3350: -- pay_run_types_f.

3346: --
3347: -- Call business rule validation.
3348: --
3349: -- Validate the run_type - if not null, check it exists on
3350: -- pay_run_types_f.
3351: --
3352: chk_run_type
3353: (p_run_type_id => p_rec.run_type_id
3354: ,p_effective_date => p_rec.effective_date