APPS.PAY_CORE_FF_UDFS dependencies on PER_ASSIGNMENTS_F

Line 788: FROM per_assignments_f ASG,

784: ASG.effective_end_date,
785: NVL(ASG.normal_hours, 0),
786: NVL(HRL.meaning, 'NOT ENTERED'),
787: NVL(SCL.segment4, 'NOT ENTERED')
788: FROM per_assignments_f ASG,
789: per_assignment_status_types AST,
790: hr_soft_coding_keyflex SCL,
791: hr_lookups HRL
792: WHERE ASG.assignment_id = p_asst_id

Line 1409: FROM per_assignments_f ASG,

1405: SELECT PYB.input_value_id,
1406: FCL.meaning
1407: INTO v_inpval_id,
1408: v_pay_basis
1409: FROM per_assignments_f ASG,
1410: per_pay_bases PYB,
1411: hr_lookups FCL
1412: WHERE FCL.lookup_code = PYB.pay_basis
1413: AND FCL.lookup_type = 'PAY_BASIS'

Line 1756: FROM per_assignments_f ASG,

1752: select 1 INTO l_asg_info_changes
1753: from dual
1754: where exists (
1755: SELECT 1
1756: FROM per_assignments_f ASG,
1757: per_assignment_status_types AST,
1758: hr_soft_coding_keyflex SCL
1759: WHERE ASG.assignment_id = p_asst_id
1760: AND ASG.effective_start_date <= p_period_start

Line 1829: FROM per_assignments_f ASG,

1825: select 1 INTO l_asg_info_changes
1826: from dual
1827: where exists (
1828: SELECT 1
1829: FROM per_assignments_f ASG,
1830: per_assignment_status_types AST,
1831: hr_soft_coding_keyflex SCL
1832: WHERE ASG.assignment_id = p_asst_id
1833: AND ASG.effective_start_date > p_period_start

Line 1923: FROM per_assignments_f ASG,

1919: hr_utility.trace(' Check assignment status of current asg record');
1920:
1921: SELECT AST.per_system_status
1922: INTO v_asg_status
1923: FROM per_assignments_f ASG,
1924: per_assignment_status_types AST,
1925: hr_soft_coding_keyflex SCL
1926: WHERE ASG.assignment_id = p_asst_id
1927: AND p_period_start BETWEEN ASG.effective_start_date

Line 1994: FROM per_assignments_f ASG,

1990: v_range_end,
1991: v_asst_std_hrs,
1992: v_asst_std_freq,
1993: v_work_schedule
1994: FROM per_assignments_f ASG,
1995: per_assignment_status_types AST,
1996: hr_soft_coding_keyflex SCL,
1997: hr_lookups HRL
1998: WHERE ASG.assignment_id = p_asst_id

Line 2081: per_assignments_f ASG,

2077: v_asst_std_freq,
2078: v_work_schedule
2079: FROM hr_soft_coding_keyflex SCL,
2080: per_assignment_status_types AST,
2081: per_assignments_f ASG,
2082: hr_lookups HRL
2083: WHERE ASG.assignment_id = p_asst_id
2084: AND ASG.business_group_id + 0 = p_bus_grp_id
2085: AND ASG.effective_start_date > p_period_start

Line 2237: FROM per_assignments_f ASG,

2233: v_range_end,
2234: v_asst_std_hrs,
2235: v_asst_std_freq,
2236: v_work_schedule
2237: FROM per_assignments_f ASG,
2238: per_assignment_status_types AST,
2239: hr_soft_coding_keyflex SCL,
2240: hr_lookups HRL
2241: WHERE ASG.assignment_id = p_asst_id

Line 2481: per_assignments_f ASG,

2477: v_asst_std_freq,
2478: v_work_schedule
2479: FROM hr_soft_coding_keyflex SCL,
2480: per_assignment_status_types AST,
2481: per_assignments_f ASG,
2482: hr_lookups HRL
2483: WHERE ASG.assignment_id = p_asst_id
2484: AND ASG.business_group_id + 0 = p_bus_grp_id
2485: AND ASG.effective_start_date > p_period_start

Line 2694: from per_assignments_f paf,

2690:
2691: CURSOR get_termination_date(l_date_earned date,
2692: l_assignment_id number) IS
2693: select actual_termination_date
2694: from per_assignments_f paf,
2695: per_periods_of_service pps
2696: where paf.assignment_id = l_assignment_id
2697: and l_date_earned between paf.effective_start_date and
2698: paf.effective_end_date

Line 3344: per_assignments_f ASS

3340: select pds.actual_termination_date
3341: ,pds.last_standard_process_date
3342: ,pds.final_process_date
3343: from per_periods_of_service PDS,
3344: per_assignments_f ASS
3345: WHERE PDS.actual_termination_date <= p_date_earned
3346: AND PDS.period_of_service_id = ASS.period_of_service_id
3347: AND p_date_earned BETWEEN ASS.effective_start_date
3348: AND ASS.effective_end_date