DBA Data[Home] [Help]

APPS.PER_SSHR_CHANGE_PAY dependencies on PAY_ELEMENT_TYPES_F

Line 1418: pay_element_types_f pet

1414: ppt.object_version_number
1415: from per_pay_transactions ppt,
1416: per_pay_bases ppb,
1417: pay_input_values_f piv,
1418: pay_element_types_f pet
1419: where ppt.assignment_id = c_assgn_id
1420: AND ppt.PARENT_PAY_TRANSACTION_ID is null
1421: AND ppt.TRANSACTION_ID = c_transaction_id
1422: AND ppt.change_date between c_changedt_last and c_changedt_curr

Line 1486: pay_element_types_f pet

1482: from per_pay_proposals pay,
1483: per_all_assignments_f paaf,
1484: per_pay_bases ppb,
1485: pay_input_values_f piv,
1486: pay_element_types_f pet
1487: where pay.assignment_id = c_assgn_id
1488: AND pay.change_date between c_changedt_last and c_changedt_curr
1489: AND pay.assignment_id = paaf.assignment_id
1490: and c_effective_dt BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 2569: pay_element_types_f pet

2565: ppt.object_version_number
2566: from per_pay_transactions ppt,
2567: per_pay_bases ppb,
2568: pay_input_values_f piv,
2569: pay_element_types_f pet
2570: where ppt.assignment_id = c_assgn_id
2571: AND ppt.PARENT_PAY_TRANSACTION_ID is null
2572: AND ppt.TRANSACTION_ID = c_transaction_id
2573: AND ppt.change_date >= c_changedate_curr