APPS.PAY_IN_INDIA_BENEFITS dependencies on PAY_PAYROLL_ACTIONS

Line 1494: ,pay_payroll_actions PACT

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
1498: ,pay_input_values_f srcInp

Line 1495: ,pay_payroll_actions BACT

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
1498: ,pay_input_values_f srcInp
1499: where BAL_ASSACT.assignment_action_id = p_asg_action_id

Line 1525: pay_payroll_actions ppa

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')
1529: AND paa.source_action_id IS NOT NULL

Line 1609: pay_payroll_actions ppa

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')
1613: AND ppa.effective_date BETWEEN p_year_start AND p_year_end

Line 1621: pay_payroll_actions ppa

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')
1625: AND ppa.effective_date BETWEEN p_year_start AND p_year_end