APPS.PAY_SG_DEDUCTIONS dependencies on PAY_BALANCE_TYPES

Line 1033: c_balance_name in pay_balance_types.balance_name%TYPE

1029: ) return varchar2 IS
1030:
1031: cursor c_earnings_type
1032: ( c_element_type_id in pay_element_types_f.element_type_id%TYPE,
1033: c_balance_name in pay_balance_types.balance_name%TYPE
1034: ) is
1035: select decode(pbt.balance_name,
1036: 'CPF Ordinary Earnings Eligible Comp', 'O',
1037: 'CPF Additional Earnings Eligible Comp', 'A', ' ')

Line 1038: from pay_balance_types pbt,

1034: ) is
1035: select decode(pbt.balance_name,
1036: 'CPF Ordinary Earnings Eligible Comp', 'O',
1037: 'CPF Additional Earnings Eligible Comp', 'A', ' ')
1038: from pay_balance_types pbt,
1039: pay_balance_feeds_f pbf,
1040: pay_input_values_f pivf,
1041: pay_element_types_f petf
1042: where pbt.balance_type_id = pbf.balance_type_id

Line 1049: l_balance_name pay_balance_types.balance_name%TYPE;

1045: and pbt.balance_name = c_balance_name
1046: and petf.element_type_id = c_element_type_id;
1047:
1048: l_earnings_type varchar2(10);
1049: l_balance_name pay_balance_types.balance_name%TYPE;
1050:
1051: begin
1052: l_earnings_type := ' ';
1053: hr_utility.set_location('Entering Earnings Type : ', 5);

Line 1149: pay_balance_types pbt,

1145: p_dimension_name in varchar2 )
1146: is
1147: select pdb.defined_balance_id
1148: from pay_defined_balances pdb,
1149: pay_balance_types pbt,
1150: pay_balance_dimensions pbd
1151: where pbt.balance_name = p_balance_name
1152: and pbd.dimension_name = p_dimension_name
1153: and pbt.balance_type_id = pdb.balance_type_id

Line 1359: pay_balance_types pbt,

1355: p_dimension_name in varchar2 )
1356: is
1357: select pdb.defined_balance_id
1358: from pay_defined_balances pdb,
1359: pay_balance_types pbt,
1360: pay_balance_dimensions pbd
1361: where pbt.balance_name = p_balance_name
1362: and pbd.dimension_name = p_dimension_name
1363: and pbt.balance_type_id = pdb.balance_type_id