APPS.PAY_US_SQWL_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1167: FROM per_assignment_extra_info paei

1163: AND org_information4 = 'Y';
1164:
1165: CURSOR c_chk_asg_wp (p_assignment_id number) IS
1166: SELECT count(*) ct
1167: FROM per_assignment_extra_info paei
1168: WHERE paei.assignment_id = p_assignment_id
1169: AND paei.information_type = 'PAY_US_ASG_STATE_WAGE_PLAN_CD'
1170: AND paei.aei_information1 = 'CA'
1171: AND paei.aei_information3 IS NOT NULL;

Line 1977: l_wage_plan_code per_assignment_extra_info.aei_information3%TYPE;

1973: l_user_entity_id NUMBER;
1974: l_context_id_assignment_id NUMBER;
1975: l_quarter_start DATE ;
1976: l_quarter_end DATE ;
1977: l_wage_plan_code per_assignment_extra_info.aei_information3%TYPE;
1978: l_assignment_id NUMBER;
1979:
1980: l_wage_plan_ct NUMBER := 0; -- Added by tmehra
1981:

Line 2025: -- FROM per_assignment_extra_info paei,

2021:
2022: -- CURSOR c_archive_wage_plan_code_rtm IS
2023: -- SELECT DISTINCT aei_information3 ,
2024: -- paf1.assignment_id
2025: -- FROM per_assignment_extra_info paei,
2026: -- pay_us_asg_reporting puar,
2027: -- pay_us_states pus ,
2028: -- per_assignments_f paf1,
2029: -- per_assignments_f paf

Line 2075: -- FROM per_assignment_extra_info paei,

2071: --
2072: -- CURSOR c_archive_wage_plan_code_rts IS
2073: -- SELECT DISTINCT aei_information3 ,
2074: -- paf1.assignment_id
2075: -- FROM per_assignment_extra_info paei,
2076: -- pay_us_asg_reporting puar,
2077: -- pay_us_states pus ,
2078: -- per_assignments_f paf1,
2079: -- per_assignments_f paf

Line 2119: FROM per_assignment_extra_info paei

2115: */
2116:
2117: CURSOR c_archive_wage_plan_code IS
2118: SELECT DISTINCT aei_information3
2119: FROM per_assignment_extra_info paei
2120: WHERE paei.assignment_id = asgid
2121: AND paei.aei_information1 = g_sqwl_state
2122: AND paei.information_type = 'PAY_US_ASG_STATE_WAGE_PLAN_CD';
2123:

Line 3389: per_assignment_extra_info paei

3385:
3386: CURSOR c_chk_asg_wp IS
3387: SELECT count(*) ct
3388: FROM per_assignments_f paf,
3389: per_assignment_extra_info paei
3390: WHERE paf.business_group_id = l_bus_group_id
3391: AND paf.effective_end_date >= l_period_start
3392: AND paf.effective_start_date <= l_period_end
3393: AND paei.information_type = 'PAY_US_ASG_STATE_WAGE_PLAN_CD'