APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 522: l_org_information_context hr_organization_information.org_information_context%type;

518: c_action_information_category constant pay_action_information.action_information_category%type := 'JP ELEMENT INFORMATION';
519: c_payment_type constant hr_lookups.lookup_code%type := 'F';
520: l_exists VARCHAR2(1);
521: l_organization_id number;
522: l_org_information_context hr_organization_information.org_information_context%type;
523: l_act_info_rec pay_emp_action_arch.act_info_rec;
524: l_result_value varchar2(255);
525: --
526: CURSOR csr_organization_info(

Line 530: FROM hr_organization_information

526: CURSOR csr_organization_info(
527: cp_organization_id NUMBER,
528: cp_org_info_context VARCHAR2) IS
529: SELECT 'Y'
530: FROM hr_organization_information
531: WHERE organization_id = cp_organization_id
532: AND org_information_context = cp_org_info_context;
533: --
534: CURSOR csr_eit_element(

Line 551: hr_organization_information hoi,

547: FROM pay_action_interlocks rpai, -- run interlock by archive assact
548: pay_assignment_actions rpaa, -- run assact
549: pay_payroll_actions rppa, -- run pact
550: pay_run_results prr,
551: hr_organization_information hoi,
552: pay_element_types_f pet,
553: pay_element_types_f_tl pettl,
554: pay_input_values_f piv,
555: pay_run_result_values prrv