DBA Data[Home] [Help]

APPS.PAY_SG_DEDUCTIONS dependencies on PAY_INPUT_VALUES_F

Line 1040: pay_input_values_f pivf,

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

Line 1506: pay_input_values_f piv,

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