DBA Data[Home] [Help]

APPS.PAY_CA_ROE_EI_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 692: pay_element_classifications elc,

688: pay_payroll_actions pya,
689: pay_run_results rrs,
690: pay_run_result_values rrv,
691: pay_element_types_f ele,
692: pay_element_classifications elc,
693: pay_input_values_f ipv,
694: pay_balance_feeds_f blf,
695: pay_balance_types blt
696: WHERE asa.assignment_id = p_asg_id

Line 848: pay_element_classifications elc,

844: pay_payroll_actions pya,
845: pay_run_results rrs,
846: pay_run_result_values rrv,
847: pay_element_types_f ele,
848: pay_element_classifications elc,
849: pay_input_values_f ipv,
850: pay_balance_feeds_f blf,
851: pay_balance_types blt
852: WHERE asa.assignment_id = p_asg_id

Line 1008: pay_element_classifications elc,

1004: pay_payroll_actions pya,
1005: pay_run_results rrs,
1006: pay_run_result_values rrv,
1007: pay_element_types_f ele,
1008: pay_element_classifications elc,
1009: pay_input_values_f ipv,
1010: pay_balance_feeds_f blf,
1011: pay_balance_types blt
1012: WHERE asa.assignment_id = p_asg_id

Line 1163: pay_element_classifications elc,

1159: pay_payroll_actions pya,
1160: pay_run_results rrs,
1161: pay_run_result_values rrv,
1162: pay_element_types_f ele,
1163: pay_element_classifications elc,
1164: pay_input_values_f ipv,
1165: pay_balance_feeds_f blf,
1166: pay_balance_types blt
1167: WHERE asa.assignment_id = p_asg_id

Line 1360: pay_element_classifications pec

1356: pay_retro_component_usages prcu,
1357: pay_element_span_usages pesu,
1358: pay_retro_components prc,
1359: pay_time_spans pts,
1360: pay_element_classifications pec
1361: where
1362: pee.assignment_id = p_assignment_id and
1363: pee.creator_type in ('EE','RR') and
1364: pee.effective_start_date <= p_end_date and

Line 2271: pay_element_classifications pec

2267: AND NVL(ele.element_information3,'DP') = p_dp_or_de
2268: UNION ALL
2269: SELECT DISTINCT ele.element_type_id
2270: FROM pay_element_types_f ele,
2271: pay_element_classifications pec
2272: WHERE ele.business_group_id is NULL
2273: AND ele.legislation_code = 'CA'
2274: AND pec.legislation_code = 'CA'
2275: AND pec.classification_name = 'Earnings'

Line 2298: pay_element_classifications pec

2294: pbf.balance_type_id = l_bal_type_id)
2295: UNION ALL
2296: SELECT DISTINCT ele.element_type_id
2297: FROM pay_element_types_f ele,
2298: pay_element_classifications pec
2299: WHERE ele.business_group_id is NULL
2300: AND ele.legislation_code = 'CA'
2301: AND pec.legislation_code = 'CA'
2302: AND pec.classification_name = 'Earnings'