[Home] [Help]
687: pay_payroll_actions pya,
688: pay_run_results rrs,
689: pay_run_result_values rrv,
690: pay_element_types_f ele,
691: pay_element_classifications elc,
692: pay_input_values_f ipv,
693: pay_balance_feeds_f blf,
694: pay_balance_types blt
695: WHERE asa.assignment_id = p_asg_id
843: pay_payroll_actions pya,
844: pay_run_results rrs,
845: pay_run_result_values rrv,
846: pay_element_types_f ele,
847: pay_element_classifications elc,
848: pay_input_values_f ipv,
849: pay_balance_feeds_f blf,
850: pay_balance_types blt
851: WHERE asa.assignment_id = p_asg_id
999: pay_payroll_actions pya,
1000: pay_run_results rrs,
1001: pay_run_result_values rrv,
1002: pay_element_types_f ele,
1003: pay_element_classifications elc,
1004: pay_input_values_f ipv,
1005: pay_balance_feeds_f blf,
1006: pay_balance_types blt
1007: WHERE asa.assignment_id = p_asg_id
1196: pay_retro_component_usages prcu,
1197: pay_element_span_usages pesu,
1198: pay_retro_components prc,
1199: pay_time_spans pts,
1200: pay_element_classifications pec
1201: where
1202: pee.assignment_id = p_assignment_id and
1203: pee.creator_type in ('EE','RR') and
1204: pee.effective_start_date <= p_end_date and
2004: AND NVL(ele.element_information3,'DP') = p_dp_or_de
2005: UNION ALL
2006: SELECT DISTINCT ele.element_type_id
2007: FROM pay_element_types_f ele,
2008: pay_element_classifications pec
2009: WHERE ele.business_group_id is NULL
2010: AND ele.legislation_code = 'CA'
2011: AND pec.legislation_code = 'CA'
2012: AND pec.classification_name = 'Earnings'
2031: pbf.balance_type_id = l_bal_type_id)
2032: UNION ALL
2033: SELECT DISTINCT ele.element_type_id
2034: FROM pay_element_types_f ele,
2035: pay_element_classifications pec
2036: WHERE ele.business_group_id is NULL
2037: AND ele.legislation_code = 'CA'
2038: AND pec.legislation_code = 'CA'
2039: AND pec.classification_name = 'Earnings'