APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 478: l_payroll_id pay_payrolls_f.payroll_id%type;

474: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
475: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
476: l_accrual_category pay_accrual_plans.accrual_category%type;
477: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
478: l_payroll_id pay_payrolls_f.payroll_id%type;
479: l_business_group_id NUMBER;
480: l_effective_date DATE;
481: l_annual_leave_balance NUMBER;
482: l_ovn NUMBER;

Line 1202: FROM pay_payrolls_f payroll

1198: /*Cursor for selecting payroll for the given payroll_action_id*/
1199: CURSOR c_payroll_id(p_payroll_action_id NUMBER) IS
1200: SELECT payroll.payroll_id
1201: , payroll.payroll_name
1202: FROM pay_payrolls_f payroll
1203: ,pay_payroll_actions ppa
1204: WHERE ppa.payroll_action_id = p_run_payroll_action_id
1205: AND ppa.payroll_id = payroll.payroll_id;
1206:

Line 1220: l_payroll_name pay_payrolls_f.payroll_name%TYPE;

1216: l_message VARCHAR2(255);
1217: l_assessment_year VARCHAR2(20);
1218: l_next_year VARCHAR2(20);
1219: l_period NUMBER;
1220: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
1221: l_payroll_id NUMBER;
1222: l_tan hr_organization_information.org_information1%TYPE;
1223: TYPE r_balance_name_val IS RECORD(l_balance_name pay_balance_types.balance_name%type,
1224: l_balance_val NUMBER);