APPS.PAY_CORE_FF_UDFS dependencies on PER_ASSIGNMENTS_F

Line 1167: FROM per_assignments_f ASG,

1163: ASG.effective_end_date,
1164: NVL(ASG.normal_hours, 0),
1165: NVL(HRL.meaning, 'NOT ENTERED'),
1166: NVL(SCL.segment4, 'NOT ENTERED')
1167: FROM per_assignments_f ASG,
1168: per_assignment_status_types AST,
1169: hr_soft_coding_keyflex SCL,
1170: hr_lookups HRL
1171: WHERE ASG.assignment_id = p_asst_id

Line 1788: FROM per_assignments_f ASG,

1784: SELECT PYB.input_value_id,
1785: FCL.meaning
1786: INTO v_inpval_id,
1787: v_pay_basis
1788: FROM per_assignments_f ASG,
1789: per_pay_bases PYB,
1790: hr_lookups FCL
1791: WHERE FCL.lookup_code = PYB.pay_basis
1792: AND FCL.lookup_type = 'PAY_BASIS'

Line 2135: FROM per_assignments_f ASG,

2131: select 1 INTO l_asg_info_changes
2132: from dual
2133: where exists (
2134: SELECT 1
2135: FROM per_assignments_f ASG,
2136: per_assignment_status_types AST,
2137: hr_soft_coding_keyflex SCL
2138: WHERE ASG.assignment_id = p_asst_id
2139: AND ASG.effective_start_date <= p_period_start

Line 2208: FROM per_assignments_f ASG,

2204: select 1 INTO l_asg_info_changes
2205: from dual
2206: where exists (
2207: SELECT 1
2208: FROM per_assignments_f ASG,
2209: per_assignment_status_types AST,
2210: hr_soft_coding_keyflex SCL
2211: WHERE ASG.assignment_id = p_asst_id
2212: AND ASG.effective_start_date > p_period_start

Line 2330: FROM per_assignments_f ASG,

2326:
2327:
2328: SELECT AST.per_system_status
2329: INTO v_asg_status
2330: FROM per_assignments_f ASG,
2331: per_assignment_status_types AST,
2332: hr_soft_coding_keyflex SCL
2333: WHERE ASG.assignment_id = p_asst_id
2334: AND p_period_start BETWEEN ASG.effective_start_date

Line 2403: FROM per_assignments_f ASG,

2399: v_range_end,
2400: v_asst_std_hrs,
2401: v_asst_std_freq,
2402: v_work_schedule
2403: FROM per_assignments_f ASG,
2404: per_assignment_status_types AST,
2405: hr_soft_coding_keyflex SCL,
2406: hr_lookups HRL
2407: WHERE ASG.assignment_id = p_asst_id

Line 2490: per_assignments_f ASG,

2486: v_asst_std_freq,
2487: v_work_schedule
2488: FROM hr_soft_coding_keyflex SCL,
2489: per_assignment_status_types AST,
2490: per_assignments_f ASG,
2491: hr_lookups HRL
2492: WHERE ASG.assignment_id = p_asst_id
2493: AND ASG.business_group_id + 0 = p_bus_grp_id
2494: AND ASG.effective_start_date > p_period_start

Line 2646: FROM per_assignments_f ASG,

2642: v_range_end,
2643: v_asst_std_hrs,
2644: v_asst_std_freq,
2645: v_work_schedule
2646: FROM per_assignments_f ASG,
2647: per_assignment_status_types AST,
2648: hr_soft_coding_keyflex SCL,
2649: hr_lookups HRL
2650: WHERE ASG.assignment_id = p_asst_id

Line 2890: per_assignments_f ASG,

2886: v_asst_std_freq,
2887: v_work_schedule
2888: FROM hr_soft_coding_keyflex SCL,
2889: per_assignment_status_types AST,
2890: per_assignments_f ASG,
2891: hr_lookups HRL
2892: WHERE ASG.assignment_id = p_asst_id
2893: AND ASG.business_group_id + 0 = p_bus_grp_id
2894: AND ASG.effective_start_date > p_period_start

Line 3103: from per_assignments_f paf,

3099:
3100: CURSOR get_termination_date(l_date_earned date,
3101: l_assignment_id number) IS
3102: select actual_termination_date
3103: from per_assignments_f paf,
3104: per_periods_of_service pps
3105: where paf.assignment_id = l_assignment_id
3106: and l_date_earned between paf.effective_start_date and
3107: paf.effective_end_date

Line 3763: per_assignments_f ASS

3759: select pds.actual_termination_date
3760: ,pds.last_standard_process_date
3761: ,pds.final_process_date
3762: from per_periods_of_service PDS,
3763: per_assignments_f ASS
3764: WHERE PDS.actual_termination_date <= p_date_earned
3765: AND PDS.period_of_service_id = ASS.period_of_service_id
3766: AND p_date_earned BETWEEN ASS.effective_start_date
3767: AND ASS.effective_end_date