[Home] [Help]
1975: from pay_balance_feeds_f pbf,
1976: pay_balance_types pbt,
1977: pay_balance_types pbt1,
1978: pay_input_values_f piv,
1979: pay_element_types_f pet,
1980: fnd_lookup_values flv
1981: where pbt.balance_name = p_balance_name
1982: and pbf.balance_type_id = pbt.balance_type_id
1983: and pbf.input_value_id = piv.input_value_id
1997: from pay_balance_feeds_f pbf,
1998: pay_balance_types pbt,
1999: pay_balance_types pbt1,
2000: pay_input_values_f piv,
2001: pay_element_types_f pet
2002: where pbt.balance_name = p_balance_name
2003: and pbf.balance_type_id = pbt.balance_type_id
2004: and pbf.input_value_id = piv.input_value_id
2005: and piv.element_type_id = pet.element_type_id
2021: run_paa.assignment_action_id
2022: from pay_run_result_values prrv1
2023: , pay_run_result_values prrv2
2024: , pay_run_results prr
2025: , pay_element_types_f pet
2026: , pay_input_values_f piv1
2027: , pay_input_values_f piv2
2028: , pay_assignment_actions run_paa
2029: , pay_payroll_actions run_ppa
3388: from pay_balance_feeds_f pbf,
3389: pay_balance_types pbt,
3390: pay_balance_types pbt1,
3391: pay_input_values_f piv,
3392: pay_element_types_f pet,
3393: fnd_lookup_values flv
3394: where pbt.balance_name = p_balance_name
3395: and pbf.balance_type_id = pbt.balance_type_id
3396: and pbf.input_value_id = piv.input_value_id
3410: from pay_balance_feeds_f pbf,
3411: pay_balance_types pbt,
3412: pay_balance_types pbt1,
3413: pay_input_values_f piv,
3414: pay_element_types_f pet
3415: where pbt.balance_name = p_balance_name
3416: and pbf.balance_type_id = pbt.balance_type_id
3417: and pbf.input_value_id = piv.input_value_id
3418: and piv.element_type_id = pet.element_type_id
3434: run_paa.assignment_action_id
3435: from pay_run_result_values prrv1
3436: , pay_run_result_values prrv2
3437: , pay_run_results prr
3438: , pay_element_types_f pet
3439: , pay_input_values_f piv1
3440: , pay_input_values_f piv2
3441: , pay_assignment_actions run_paa
3442: , pay_payroll_actions run_ppa