APPS.PAY_SG_DEDUCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 781: pay_element_types_f pet

777: pay_assignment_actions paa,
778: pay_payroll_actions ppa,
779: pay_element_sets pes,
780: pay_element_type_rules petr,
781: pay_element_types_f pet
782: where pee.creator_id = paa.assignment_action_id
783: and pee.assignment_id = c_assignment_id
784: and pee.creator_type in ('EE', 'RR')
785: and pee.element_entry_id = c_element_entry_id

Line 851: p_element_type_id in pay_element_types_f.element_type_id%TYPE

847: */
848:
849: function earnings_type
850: (
851: p_element_type_id in pay_element_types_f.element_type_id%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,

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

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

Line 864: pay_element_types_f petf

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
866: and pbf.input_value_id = pivf.input_value_id
867: and pivf.element_type_id = petf.element_type_id
868: and pbt.balance_name = c_balance_name

Line 1278: pay_element_types_f pet,

1274: is
1275: select sum(peev.screen_entry_value)
1276: from pay_element_entry_values_f peev,
1277: pay_element_entries_f pee,
1278: pay_element_types_f pet,
1279: pay_input_values_f piv,
1280: pay_element_classifications pec
1281: where pee.assignment_id = p_assignment_id
1282: and pee.source_asg_action_id in