APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 148: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay

144: pay_payroll_actions ppa1, -- payroll run/quickpay action
145: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
146: pay_input_values_f piv, -- "Pay values" of type Money
147: pay_run_results prr, -- run result created by the payroll run/quick pay
148: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay
149: WHERE lck.locking_action_id = paa2.assignment_action_id
150: AND paa2.payroll_action_id = pai.action_context_id
151: AND pai.action_context_type = 'PA'
152: AND pai.action_information_category = 'EMEA ELEMENT DEFINITION'

Line 1718: FROM pay_run_result_values prv,

1714: CURSOR csr_element_values (p_assignment_action_id NUMBER,
1715: p_element_type_id NUMBER,
1716: p_input_value_id NUMBER) IS
1717: SELECT prv.result_value
1718: FROM pay_run_result_values prv,
1719: pay_run_results prr
1720: WHERE prr.status IN ('P','PA')
1721: AND prv.run_result_id = prr.run_result_id
1722: AND prr.assignment_action_id = p_assignment_action_id

Line 1736: l_result_value pay_run_result_values.result_value%TYPE;

1732: l_ovn NUMBER;
1733: l_record_count VARCHAR2(10);
1734:
1735: -- Added for bug 5387406
1736: l_result_value pay_run_result_values.result_value%TYPE;
1737:
1738: --12740029
1739: Cursor c_other_child_asg_act_id(p_assignment_id NUMBER, p_effective_date DATE, p_child_asg_act_id NUMBER)
1740: IS

Line 1765: l_result_value1 pay_run_result_values.result_value%type;

1761: );
1762:
1763: l_oth_child_asg_action_id NUMBER;
1764: l_child_assignment_action NUMBER;
1765: l_result_value1 pay_run_result_values.result_value%type;
1766: l_run_method varchar2(100);
1767: --12740029
1768:
1769: