[Home] [Help]
10: --
11: -- Bug c_context_name - PRSI Context Balance Design Change
12: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
13: l_context_id ff_contexts.context_id%TYPE;
14: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
15: p_person_id_global per_people_f.person_id%TYPE; -- to store the person_id in a package level variable to be used in c_context_name cursor
16: l_class_count NUMBER (4);
17: l_weeks_at_initial_class NUMBER (4);
18: l_weeks_at_second_class NUMBER (4);
640: IS
641: SELECT pdb.defined_balance_id
642: FROM pay_balance_dimensions pbd,
643: pay_balance_types pbt,
644: pay_defined_balances pdb
645: WHERE pbd.dimension_name = p_dimension_name
646: AND pbd.business_group_id IS NULL
647: AND pbd.legislation_code = 'IE'
648: AND pbt.balance_name = p_balance_name
652: AND pdb.balance_dimension_id = pbd.balance_dimension_id
653: AND pdb.business_group_id IS NULL
654: AND pdb.legislation_code = 'IE';
655:
656: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
657: BEGIN
658: OPEN csr_defined_balance_id;
659: FETCH csr_defined_balance_id INTO l_defined_balance_id;
660: CLOSE csr_defined_balance_id;
1621: SELECT SUBSTR (pai1.action_information4, 1, 30) bval
1622: FROM pay_action_information pai1,
1623: pay_balance_types pbt,
1624: pay_balance_dimensions pbd,
1625: pay_defined_balances pdb
1626: WHERE pdb.balance_type_id = pbt.balance_type_id
1627: AND pbt.legislation_code = 'IE'
1628: AND UPPER (pbt.balance_name) = p_balance_name
1629: AND pbd.legislation_code = 'IE'