APPS.PAY_US_SQWL_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1097: FROM per_assignment_extra_info paei

1093: AND org_information4 = 'Y';
1094:
1095: CURSOR c_chk_asg_wp (p_assignment_id number) IS
1096: SELECT count(*) ct
1097: FROM per_assignment_extra_info paei
1098: WHERE paei.assignment_id = p_assignment_id
1099: AND paei.information_type = 'PAY_US_ASG_STATE_WAGE_PLAN_CD'
1100: AND paei.aei_information1 = 'CA'
1101: AND paei.aei_information3 IS NOT NULL;

Line 1879: l_wage_plan_code per_assignment_extra_info.aei_information3%TYPE;

1875: l_user_entity_id NUMBER;
1876: l_context_id_assignment_id NUMBER;
1877: l_quarter_start DATE ;
1878: l_quarter_end DATE ;
1879: l_wage_plan_code per_assignment_extra_info.aei_information3%TYPE;
1880: l_assignment_id NUMBER;
1881:
1882: l_wage_plan_ct NUMBER := 0; -- Added by tmehra
1883:

Line 1927: -- FROM per_assignment_extra_info paei,

1923:
1924: -- CURSOR c_archive_wage_plan_code_rtm IS
1925: -- SELECT DISTINCT aei_information3 ,
1926: -- paf1.assignment_id
1927: -- FROM per_assignment_extra_info paei,
1928: -- pay_us_asg_reporting puar,
1929: -- pay_us_states pus ,
1930: -- per_assignments_f paf1,
1931: -- per_assignments_f paf

Line 1977: -- FROM per_assignment_extra_info paei,

1973: --
1974: -- CURSOR c_archive_wage_plan_code_rts IS
1975: -- SELECT DISTINCT aei_information3 ,
1976: -- paf1.assignment_id
1977: -- FROM per_assignment_extra_info paei,
1978: -- pay_us_asg_reporting puar,
1979: -- pay_us_states pus ,
1980: -- per_assignments_f paf1,
1981: -- per_assignments_f paf

Line 2021: FROM per_assignment_extra_info paei

2017: */
2018:
2019: CURSOR c_archive_wage_plan_code IS
2020: SELECT DISTINCT aei_information3
2021: FROM per_assignment_extra_info paei
2022: WHERE paei.assignment_id = asgid
2023: AND paei.aei_information1 = g_sqwl_state
2024: AND paei.information_type = 'PAY_US_ASG_STATE_WAGE_PLAN_CD';
2025:

Line 2452: per_assignment_extra_info paei

2448:
2449: CURSOR c_chk_asg_wp IS
2450: SELECT count(*) ct
2451: FROM per_assignments_f paf,
2452: per_assignment_extra_info paei
2453: WHERE paf.business_group_id = l_bus_group_id
2454: AND paf.effective_end_date >= l_period_start
2455: AND paf.effective_start_date <= l_period_end
2456: AND paei.information_type = 'PAY_US_ASG_STATE_WAGE_PLAN_CD'