DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PER_ALL_ASSIGNMENTS_F

Line 64: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

60: l_curr_org_id pa_expenditures_all.org_id%TYPE; /* Added for bug 7365397 */
61: l_rate_source_code pa_compensation_rule_sets.rate_source_code%TYPE; /* added for 12.2 . bug 10253400 */
62: l_base_hours pa_org_labor_sch_rule.base_hours%TYPE; /* 12.2 payroll intg .. bug 11811475 */
63: l_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE; /* 12.2 payroll intg .. bug 11811475 */
64: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
65: l_rbc_rate number;
66:
67: begin
68:

Line 461: from per_all_assignments_f

457: if ( l_rate_source_code = 'HR_RATES' ) then
458:
459: select assignment_id
460: into l_assignment_id
461: from per_all_assignments_f
462: where person_id = p_person_id
463: and p_txn_date between effective_start_date and nvl(effective_end_date, p_txn_date)
464: and primary_flag = 'Y';
465: