DBA Data[Home] [Help]

APPS.PAY_IE_PRSI dependencies on PAY_BALANCE_DIMENSIONS

Line 53: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE

49: /* knadhan */
50: FUNCTION get_bal_value_30_04_09 (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
51: ,p_tax_unit_id IN NUMBER
52: ,p_balance_name IN pay_balance_types.balance_name%TYPE
53: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
54: ,p_till_date IN DATE) RETURN number IS
55: CURSOR cur_assignment_action is
56: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
57: paa.assignment_action_id),16))

Line 68: FROM pay_balance_dimensions pbd

64: AND paa.source_action_id is null
65: AND ppa.effective_date<= p_till_date;
66: CURSOR cur_defined_balance_id is
67: SELECT pdb.defined_balance_id
68: FROM pay_balance_dimensions pbd
69: ,pay_defined_balances pdb
70: ,pay_balance_types pbt
71: WHERE pbt.balance_name = p_balance_name
72: AND pbt.legislation_code='IE'