APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1549: ,pay_assignment_actions ASSACT

1545: SELECT sum(nvl(target.result_value,0) )
1546: FROM pay_run_result_values TARGET
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

Line 1550: ,pay_assignment_actions BAL_ASSACT

1546: FROM pay_run_result_values TARGET
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

Line 1581: FROM pay_assignment_actions paa,

1577:
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')

Line 1665: FROM pay_assignment_actions paa,

1661: RETURN NUMBER IS
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')

Line 1677: FROM pay_assignment_actions paa,

1673:
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')