APPS.HR_BALANCE_FEEDS dependencies on PAY_PAYROLL_ACTIONS

Line 1581: pay_payroll_actions pa

1577: INDEX(rrv PAY_RUN_RESULT_VALUES_PK) */ null
1578: from pay_run_result_values rrv,
1579: pay_run_results rr,
1580: pay_assignment_actions aa,
1581: pay_payroll_actions pa
1582: where rrv.input_value_id = p_input_value_id
1583: and rr.run_result_id = rrv.run_result_id
1584: and rr.status like 'P%'
1585: and aa.assignment_action_id = rr.assignment_action_id

Line 1669: pay_payroll_actions pa

1665: null
1666: from pay_run_result_values rrv,
1667: pay_run_results rr,
1668: pay_assignment_actions aa,
1669: pay_payroll_actions pa
1670: where rrv.input_value_id = bf.input_value_id
1671: and rr.run_result_id = rrv.run_result_id
1672: and rr.status like 'P%'
1673: and aa.assignment_action_id = rr.assignment_action_id

Line 1692: INDEX(pa PAY_PAYROLL_ACTIONS_PK)

1688: USE_NL(rrv rr aa pa)
1689: INDEX(rrv PAY_RUN_RESULT_VALUES_PK)
1690: INDEX(rr PAY_RUN_RESULTS_PK)
1691: INDEX(aa PAY_ASSIGNMENT_ACTIONS_PK)
1692: INDEX(pa PAY_PAYROLL_ACTIONS_PK)
1693: */ 1
1694: from pay_run_result_values rrv,
1695: pay_run_results rr,
1696: pay_assignment_actions aa,

Line 1697: pay_payroll_actions pa

1693: */ 1
1694: from pay_run_result_values rrv,
1695: pay_run_results rr,
1696: pay_assignment_actions aa,
1697: pay_payroll_actions pa
1698: where rrv.input_value_id = p_input_value_id
1699: and rr.run_result_id = rrv.run_result_id
1700: and rr.status like 'P%'
1701: and aa.assignment_action_id = rr.assignment_action_id

Line 1711: select /*+ INDEX(pa pay_payroll_actions_n5)*/

1707: (
1708: p_validation_start_date date,
1709: p_validation_end_date date
1710: ) is
1711: select /*+ INDEX(pa pay_payroll_actions_n5)*/
1712: payroll_action_id
1713: from pay_payroll_actions pa
1714: where pa.effective_date between p_validation_start_date
1715: and p_validation_end_date

Line 1713: from pay_payroll_actions pa

1709: p_validation_end_date date
1710: ) is
1711: select /*+ INDEX(pa pay_payroll_actions_n5)*/
1712: payroll_action_id
1713: from pay_payroll_actions pa
1714: where pa.effective_date between p_validation_start_date
1715: and p_validation_end_date
1716: and action_type in ('R', 'Q', 'B', 'I', 'V')
1717: order by payroll_action_id desc;