APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_PAYROLLS_F

Line 548: l_payroll_id pay_payrolls_f.payroll_id%type;

544: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%type;
545: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%type;
546: l_accrual_category pay_accrual_plans.accrual_category%type;
547: l_accrual_uom pay_accrual_plans.accrual_units_of_measure%type;
548: l_payroll_id pay_payrolls_f.payroll_id%type;
549: l_business_group_id NUMBER;
550: l_effective_date DATE;
551: l_annual_leave_balance NUMBER;
552: l_ovn NUMBER;

Line 1275: FROM pay_payrolls_f payroll

1271: /*Cursor for selecting payroll for the given payroll_action_id*/
1272: CURSOR c_payroll_id(p_payroll_action_id NUMBER) IS
1273: SELECT payroll.payroll_id
1274: , payroll.payroll_name
1275: FROM pay_payrolls_f payroll
1276: ,pay_payroll_actions ppa
1277: WHERE ppa.payroll_action_id = p_run_payroll_action_id
1278: AND ppa.payroll_id = payroll.payroll_id;
1279:

Line 1321: l_payroll_name pay_payrolls_f.payroll_name%TYPE;

1317: l_message VARCHAR2(255);
1318: l_assessment_year VARCHAR2(20);
1319: l_next_year VARCHAR2(20);
1320: l_period NUMBER;
1321: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
1322: l_payroll_id NUMBER;
1323: l_tan hr_organization_information.org_information1%TYPE;
1324: TYPE r_balance_name_val IS RECORD(l_balance_name pay_balance_types.balance_name%type,
1325: l_balance_val NUMBER);