DBA Data[Home] [Help]

APPS.PER_SSHR_CHANGE_PAY dependencies on PAY_ELEMENT_TYPES_F

Line 1406: pay_element_types_f pet

1402: ppt.object_version_number
1403: from per_pay_transactions ppt,
1404: per_pay_bases ppb,
1405: pay_input_values_f piv,
1406: pay_element_types_f pet
1407: where ppt.assignment_id = c_assgn_id
1408: AND ppt.PARENT_PAY_TRANSACTION_ID is null
1409: AND ppt.TRANSACTION_ID = c_transaction_id
1410: AND ppt.change_date between c_changedt_last and c_changedt_curr

Line 1474: pay_element_types_f pet

1470: from per_pay_proposals pay,
1471: per_all_assignments_f paaf,
1472: per_pay_bases ppb,
1473: pay_input_values_f piv,
1474: pay_element_types_f pet
1475: where pay.assignment_id = c_assgn_id
1476: AND pay.change_date between c_changedt_last and c_changedt_curr
1477: AND pay.assignment_id = paaf.assignment_id
1478: and c_effective_dt BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 2538: pay_element_types_f pet

2534: ppt.object_version_number
2535: from per_pay_transactions ppt,
2536: per_pay_bases ppb,
2537: pay_input_values_f piv,
2538: pay_element_types_f pet
2539: where ppt.assignment_id = c_assgn_id
2540: AND ppt.PARENT_PAY_TRANSACTION_ID is null
2541: AND ppt.TRANSACTION_ID = c_transaction_id
2542: AND ppt.change_date >= c_changedate_curr