[Home] [Help]
1761: */
1762:
1763: FUNCTION check_if_enhanced_retro
1764: (
1765: p_business_group_id IN per_business_groups.business_group_id%TYPE
1766: )RETURN VARCHAR2
1767: IS
1768:
1769: CURSOR get_legislation_rule
1766: )RETURN VARCHAR2
1767: IS
1768:
1769: CURSOR get_legislation_rule
1770: (c_business_group_id IN per_business_groups.business_group_id%TYPE)
1771: IS
1772: SELECT rule_mode
1773: FROM pay_legislation_rules plr
1774: ,per_business_groups pbg
1770: (c_business_group_id IN per_business_groups.business_group_id%TYPE)
1771: IS
1772: SELECT rule_mode
1773: FROM pay_legislation_rules plr
1774: ,per_business_groups pbg
1775: WHERE plr.legislation_code = pbg.legislation_code
1776: AND pbg.business_group_id = c_business_group_id
1777: AND plr.rule_type = 'ADVANCED_RETRO'
1778: AND pbg.legislation_code = 'AU';
3492: (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
3493: ,p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
3494: ,p_payroll_id IN pay_payroll_actions.payroll_id%TYPE
3495: ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
3496: ,p_business_group_id IN per_business_groups.business_group_id%TYPE
3497: ,p_date_earned IN pay_payroll_actions.date_earned%TYPE
3498: ,p_period_start_date IN DATE
3499: ,p_emp_hire_date IN DATE
3500: ,p_earnings_std_ytd IN NUMBER
4511: IS
4512:
4513: error_code number;
4514: error_message varchar2(255);
4515: l_business_group_name per_business_groups.name%type;
4516: l_run_mode VARCHAR2(60);
4517:
4518: type number_table is table of number not null index by binary_integer;
4519: type screen_entry_values is table of pay_element_entry_values_f.screen_entry_value%TYPE index by binary_integer;
4818:
4819: BEGIN
4820:
4821: select distinct name into l_business_group_name
4822: from per_business_groups
4823: where business_group_id = p_business_group_id;
4824:
4825: select decode(p_mode, 'L', 'Listing Mode', 'A','All','U','Upgrading Mode','Future Upgrade') into l_run_mode from dual;
4826: