DBA Data[Home] [Help]

APPS.PAY_CORE_UTILS dependencies on PAY_RUN_RESULTS

Line 721: select pay_run_results_s.nextval

717: is
718: rr_id number;
719: begin
720: --
721: select pay_run_results_s.nextval
722: into rr_id
723: from sys.dual;
724: --
725: p_rr_id_list := rr_id;

Line 1789: from pay_run_results prr,

1785: cursor c_procsep (p_aa_id number,
1786: p_eff_date date)
1787: is
1788: select prr.source_id
1789: from pay_run_results prr,
1790: pay_element_types_f pet
1791: where prr.assignment_action_id = p_aa_id
1792: and prr.source_type = 'E'
1793: and prr.element_type_id = pet.element_type_id

Line 1808: l_ee_id pay_run_results.source_id%type;

1804: 2);
1805: --
1806: l_run_meth pay_run_types_f.run_method%type;
1807: l_eff_date pay_payroll_actions.effective_date%type;
1808: l_ee_id pay_run_results.source_id%type;
1809: --
1810: begin
1811: --
1812: select nvl(prt.run_method, 'N'),