DBA Data[Home] [Help]

APPS.PAY_ZA_EOY_VAL dependencies on PAY_ELEMENT_TYPES_F

Line 745: pay_element_types_f pet,

741: CURSOR elem_names_cur (p_asgn_ac_id pay_assignment_actions.assignment_action_id%type)IS
742: Select element_name
743: FROM pay_assignment_actions paa,
744: pay_payroll_actions ppa,
745: pay_element_types_f pet,
746: pay_input_values_f piv,
747: pay_run_results prr,
748: pay_run_result_values prv
749: Where paa.assignment_action_id = p_asgn_ac_id

Line 847: , pay_element_types_f ELEM

843: , pay_payroll_actions PACT
844: , pay_assignment_actions ASSACT
845: , pay_payroll_actions BACT
846: , pay_assignment_actions BAL_ASSACT
847: , pay_element_types_f ELEM
848: where BAL_ASSACT.assignment_action_id = p_asgn_action_id
849: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
850: and FEED.input_value_id = TARGET.input_value_id
851: and TARGET.run_result_id = RR.run_result_id

Line 4154: , pay_element_types_f ELEM

4150: , pay_payroll_actions PACT
4151: , pay_assignment_actions ASSACT
4152: , pay_payroll_actions BACT
4153: , pay_assignment_actions BAL_ASSACT
4154: , pay_element_types_f ELEM
4155: , pay_balance_types PBT
4156: where BAL_ASSACT.assignment_action_id = p_asgn_action_id
4157: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
4158: and FEED.input_value_id = TARGET.input_value_id