DBA Data[Home] [Help]

APPS.PAY_SG_PAYSLIP_ARCHIVE dependencies on PAY_ACCRUAL_PLANS

Line 650: FROM pay_accrual_plans pap,

646: , pap.accrual_units_of_measure
647: , ppa.payroll_id
648: , pap.business_group_id
649: , pap.accrual_plan_id
650: FROM pay_accrual_plans pap,
651: pay_element_types_f pet,
652: pay_element_links_f pel,
653: pay_element_entries_f pee,
654: pay_assignment_actions paa,

Line 675: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;

671: AND paa.assignment_action_id = p_assignment_action_id;
672:
673:
674: l_action_info_id NUMBER;
675: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
676: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
677: l_accrual_category pay_accrual_plans.accrual_category%type;
678: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
679: l_payroll_id pay_all_payrolls_f.payroll_id%type;

Line 676: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;

672:
673:
674: l_action_info_id NUMBER;
675: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
676: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
677: l_accrual_category pay_accrual_plans.accrual_category%type;
678: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
679: l_payroll_id pay_all_payrolls_f.payroll_id%type;
680: l_procedure_name VARCHAR2(80);

Line 677: l_accrual_category pay_accrual_plans.accrual_category%type;

673:
674: l_action_info_id NUMBER;
675: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
676: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
677: l_accrual_category pay_accrual_plans.accrual_category%type;
678: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
679: l_payroll_id pay_all_payrolls_f.payroll_id%type;
680: l_procedure_name VARCHAR2(80);
681: l_business_group_id NUMBER;

Line 678: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;

674: l_action_info_id NUMBER;
675: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
676: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
677: l_accrual_category pay_accrual_plans.accrual_category%type;
678: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
679: l_payroll_id pay_all_payrolls_f.payroll_id%type;
680: l_procedure_name VARCHAR2(80);
681: l_business_group_id NUMBER;
682: l_effective_date DATE;