DBA Data[Home] [Help]

APPS.PAY_SG_DEDUCTIONS dependencies on PAY_INPUT_VALUES_F

Line 863: pay_input_values_f pivf,

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

Line 1279: pay_input_values_f piv,

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
1283: (select paa1.assignment_action_id