APPS.PAY_SG_DEDUCTIONS dependencies on PAY_BALANCE_TYPES

Line 856: c_balance_name in pay_balance_types.balance_name%TYPE

852: ) return varchar2 IS
853:
854: cursor c_earnings_type
855: ( c_element_type_id in pay_element_types_f.element_type_id%TYPE,
856: c_balance_name in pay_balance_types.balance_name%TYPE
857: ) is
858: select decode(pbt.balance_name,
859: 'CPF Ordinary Earnings Eligible Comp', 'O',
860: 'CPF Additional Earnings Eligible Comp', 'A', ' ')

Line 861: from pay_balance_types pbt,

857: ) is
858: select decode(pbt.balance_name,
859: 'CPF Ordinary Earnings Eligible Comp', 'O',
860: 'CPF Additional Earnings Eligible Comp', 'A', ' ')
861: from pay_balance_types pbt,
862: pay_balance_feeds_f pbf,
863: pay_input_values_f pivf,
864: pay_element_types_f petf
865: where pbt.balance_type_id = pbf.balance_type_id

Line 872: l_balance_name pay_balance_types.balance_name%TYPE;

868: and pbt.balance_name = c_balance_name
869: and petf.element_type_id = c_element_type_id;
870:
871: l_earnings_type varchar2(10);
872: l_balance_name pay_balance_types.balance_name%TYPE;
873:
874: begin
875: l_earnings_type := ' ';
876: hr_utility.set_location('Entering Earnings Type : ', 5);

Line 972: pay_balance_types pbt,

968: p_dimension_name in varchar2 )
969: is
970: select pdb.defined_balance_id
971: from pay_defined_balances pdb,
972: pay_balance_types pbt,
973: pay_balance_dimensions pbd
974: where pbt.balance_name = p_balance_name
975: and pbd.dimension_name = p_dimension_name
976: and pbt.balance_type_id = pdb.balance_type_id

Line 1157: pay_balance_types pbt,

1153: p_dimension_name in varchar2 )
1154: is
1155: select pdb.defined_balance_id
1156: from pay_defined_balances pdb,
1157: pay_balance_types pbt,
1158: pay_balance_dimensions pbd
1159: where pbt.balance_name = p_balance_name
1160: and pbd.dimension_name = p_dimension_name
1161: and pbt.balance_type_id = pdb.balance_type_id