APPS.PQH_COMMITMENT_PKG dependencies on PAY_PAYROLLS_F

Line 1133: l_period_type pay_payrolls_f.period_type%type;

1129: --
1130: Function get_payroll_period_type(p_payroll_id in number,
1131: p_effective_dt in date) RETURN varchar2 is
1132: --
1133: l_period_type pay_payrolls_f.period_type%type;
1134: --
1135: -- Pick up the period type available for a payroll as of the commitment calculation date.
1136: --
1137: Cursor csr_period_type is

Line 1139: FROM pay_payrolls_f PRL

1135: -- Pick up the period type available for a payroll as of the commitment calculation date.
1136: --
1137: Cursor csr_period_type is
1138: SELECT PRL.period_type
1139: FROM pay_payrolls_f PRL
1140: WHERE PRL.payroll_id = p_payroll_id
1141: AND p_effective_dt BETWEEN PRL.effective_start_date AND PRL.effective_end_date;
1142: --
1143: l_proc varchar2(72) := g_package||'get_payroll_period_type';

Line 3360: l_payroll_period_type pay_payrolls_f.period_type%type;

3356: v_work_sched_name VARCHAR2(80);
3357: v_ws_id NUMBER(9);
3358: v_period_hours BOOLEAN;
3359: --
3360: l_payroll_period_type pay_payrolls_f.period_type%type;
3361: --
3362: BEGIN -- Get_Annualizing_Factor
3363: --
3364: --

Line 3718: from PAY_PAYROLLS_f

3714: --
3715: --
3716: Cursor csr_get_period_frequency IS
3717: Select period_type
3718: from PAY_PAYROLLS_f
3719: where payroll_id = (Select payroll_id
3720: from per_all_assignments_f
3721: where assignment_id = p_assignment_id);
3722: ---

Line 3772: l_period_frequency PAY_PAYROLLS_f.period_type%type;

3768: l_budget_version_id Number;
3769: l_cmmtmnt_end_dt date;
3770: l_dummy_tab cmmtmnt_elmnts_tab;
3771: l_status number(15);
3772: l_period_frequency PAY_PAYROLLS_f.period_type%type;
3773: l_pay_basis_id per_all_assignments_f.pay_basis_id%type;
3774: l_business_group_id per_all_assignments_f.business_group_id%type;
3775: l_payroll_id per_all_assignments_f.payroll_id%type;
3776: l_normal_hours per_all_assignments_f.normal_hours%type;