APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1492: ,pay_assignment_actions ASSACT

1488: SELECT sum(nvl(target.result_value,0) )
1489: FROM pay_run_result_values TARGET
1490: ,pay_balance_feeds_f FEED
1491: ,pay_run_results RR
1492: ,pay_assignment_actions ASSACT
1493: ,pay_assignment_actions BAL_ASSACT
1494: ,pay_payroll_actions PACT
1495: ,pay_payroll_actions BACT
1496: ,pay_input_values_f piv

Line 1493: ,pay_assignment_actions BAL_ASSACT

1489: FROM pay_run_result_values TARGET
1490: ,pay_balance_feeds_f FEED
1491: ,pay_run_results RR
1492: ,pay_assignment_actions ASSACT
1493: ,pay_assignment_actions BAL_ASSACT
1494: ,pay_payroll_actions PACT
1495: ,pay_payroll_actions BACT
1496: ,pay_input_values_f piv
1497: ,pay_run_result_values srcVal

Line 1524: FROM pay_assignment_actions paa,

1520:
1521: CURSOR csr_max_assact_id(p_asg_id IN NUMBER)
1522: IS
1523: SELECT assignment_action_id
1524: FROM pay_assignment_actions paa,
1525: pay_payroll_actions ppa
1526: WHERE paa.assignment_id = p_asg_id
1527: AND paa.payroll_action_id = PPA.PAYROLL_ACTION_ID
1528: AND ppa.action_type in('R','Q','B','I')

Line 1608: FROM pay_assignment_actions paa,

1604: RETURN NUMBER IS
1605: CURSOR csr_get_max_assact(p_year_start DATE
1606: ,p_year_end DATE) IS
1607: SELECT assignment_action_id
1608: FROM pay_assignment_actions paa,
1609: pay_payroll_actions ppa
1610: WHERE paa.assignment_id = p_asg_id
1611: AND paa.payroll_action_id = PPA.PAYROLL_ACTION_ID
1612: AND ppa.action_type in('R','Q','B','I')

Line 1620: FROM pay_assignment_actions paa,

1616:
1617: CURSOR csr_exists(p_year_start DATE
1618: ,p_year_end DATE) IS
1619: SELECT assignment_action_id
1620: FROM pay_assignment_actions paa,
1621: pay_payroll_actions ppa
1622: WHERE paa.assignment_id = p_asg_id
1623: AND paa.payroll_action_id = PPA.PAYROLL_ACTION_ID
1624: AND ppa.action_type in('R','Q','B','I')