APPS.PAY_SG_DEDUCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 958: pay_element_types_f pet

954: pay_assignment_actions paa,
955: pay_payroll_actions ppa,
956: pay_element_sets pes,
957: pay_element_type_rules petr,
958: pay_element_types_f pet
959: where pee.creator_id = paa.assignment_action_id
960: and pee.assignment_id = c_assignment_id
961: and pee.creator_type in ('EE', 'RR')
962: and pee.element_entry_id = c_element_entry_id

Line 1028: p_element_type_id in pay_element_types_f.element_type_id%TYPE

1024: */
1025:
1026: function earnings_type
1027: (
1028: p_element_type_id in pay_element_types_f.element_type_id%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,

Line 1032: ( c_element_type_id in pay_element_types_f.element_type_id%TYPE,

1028: p_element_type_id in pay_element_types_f.element_type_id%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',

Line 1041: pay_element_types_f petf

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
1043: and pbf.input_value_id = pivf.input_value_id
1044: and pivf.element_type_id = petf.element_type_id
1045: and pbt.balance_name = c_balance_name

Line 1505: pay_element_types_f pet,

1501: is
1502: select sum(peev.screen_entry_value)
1503: from pay_element_entry_values_f peev,
1504: pay_element_entries_f pee,
1505: pay_element_types_f pet,
1506: pay_input_values_f piv,
1507: pay_element_classifications pec
1508: where pee.assignment_id = p_assignment_id
1509: and pee.source_asg_action_id in