APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_PAYROLL_ACTIONS

Line 1551: ,pay_payroll_actions PACT

1547: ,pay_balance_feeds_f FEED
1548: ,pay_run_results RR
1549: ,pay_assignment_actions ASSACT
1550: ,pay_assignment_actions BAL_ASSACT
1551: ,pay_payroll_actions PACT
1552: ,pay_payroll_actions BACT
1553: ,pay_input_values_f piv
1554: ,pay_run_result_values srcVal
1555: ,pay_input_values_f srcInp

Line 1552: ,pay_payroll_actions BACT

1548: ,pay_run_results RR
1549: ,pay_assignment_actions ASSACT
1550: ,pay_assignment_actions BAL_ASSACT
1551: ,pay_payroll_actions PACT
1552: ,pay_payroll_actions BACT
1553: ,pay_input_values_f piv
1554: ,pay_run_result_values srcVal
1555: ,pay_input_values_f srcInp
1556: where BAL_ASSACT.assignment_action_id = p_asg_action_id

Line 1582: pay_payroll_actions ppa

1578: CURSOR csr_max_assact_id(p_asg_id IN NUMBER)
1579: IS
1580: SELECT assignment_action_id
1581: FROM pay_assignment_actions paa,
1582: pay_payroll_actions ppa
1583: WHERE paa.assignment_id = p_asg_id
1584: AND paa.payroll_action_id = PPA.PAYROLL_ACTION_ID
1585: AND ppa.action_type in('R','Q','B','I')
1586: AND paa.source_action_id IS NOT NULL

Line 1666: pay_payroll_actions ppa

1662: CURSOR csr_get_max_assact(p_year_start DATE
1663: ,p_year_end DATE) IS
1664: SELECT assignment_action_id
1665: FROM pay_assignment_actions paa,
1666: pay_payroll_actions ppa
1667: WHERE paa.assignment_id = p_asg_id
1668: AND paa.payroll_action_id = PPA.PAYROLL_ACTION_ID
1669: AND ppa.action_type in('R','Q','B','I')
1670: AND ppa.effective_date BETWEEN p_year_start AND p_year_end

Line 1678: pay_payroll_actions ppa

1674: CURSOR csr_exists(p_year_start DATE
1675: ,p_year_end DATE) IS
1676: SELECT assignment_action_id
1677: FROM pay_assignment_actions paa,
1678: pay_payroll_actions ppa
1679: WHERE paa.assignment_id = p_asg_id
1680: AND paa.payroll_action_id = PPA.PAYROLL_ACTION_ID
1681: AND ppa.action_type in('R','Q','B','I')
1682: AND ppa.effective_date BETWEEN p_year_start AND p_year_end