APPS.PAY_SE_GENERAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 42: from pay_range_tables_f PRTF ,pay_ranges_f PRF,per_all_assignments_f PAAF

38: cursor csr_amount(ROM char,PERIOD Number,Tax_Base Number)
39: is
40: select amount1,amount2,amount3,amount4,amount5
41: INTO l_amount1,l_amount2,l_amount3,l_amount4,l_amount5
42: from pay_range_tables_f PRTF ,pay_ranges_f PRF,per_all_assignments_f PAAF
43: where PAAF.ASSIGNMENT_ID = p_ASSIGNMENT_ID
44: --and PAAF.BUSINESS_GROUP_ID = PRTF.BUSINESS_GROUP_ID
45: and PRTF.LEGISLATION_CODE='SE'
46: and PRTF.range_table_id = PRF.range_table_id

Line 67: from per_all_assignments_f PAAF,per_all_people_f PAPF

63:
64: cursor csr_Get_Age
65: is
66: select floor((months_between(TRUNC(p_DATE_EARNED,'yyyy') ,PAPF.DATE_OF_BIRTH ))/12)
67: from per_all_assignments_f PAAF,per_all_people_f PAPF
68: where PAAF.ASSIGNMENT_ID =p_ASSIGNMENT_ID
69: and PAAF.PERSON_ID = PAPF.PERSON_ID
70: and PAAF.BUSINESS_GROUP_ID= PAPF.BUSINESS_GROUP_ID
71: and p_DATE_EARNED between

Line 227: FROM per_all_assignments_f asg1

223: IS
224: --
225: CURSOR get_details(csr_v_input_value VARCHAR2 ) IS
226: SELECT eev1.screen_entry_value screen_entry_value
227: FROM per_all_assignments_f asg1
228: ,per_all_assignments_f asg2
229: ,per_all_people_f per
230: ,pay_element_links_f el
231: ,pay_element_types_f et

Line 228: ,per_all_assignments_f asg2

224: --
225: CURSOR get_details(csr_v_input_value VARCHAR2 ) IS
226: SELECT eev1.screen_entry_value screen_entry_value
227: FROM per_all_assignments_f asg1
228: ,per_all_assignments_f asg2
229: ,per_all_people_f per
230: ,pay_element_links_f el
231: ,pay_element_types_f et
232: ,pay_input_values_f iv1

Line 415: per_all_assignments_f paaf,

411: p_ASG_Absent_hours Number
412: )
413: IS
414: select Hourly_Salaried_Code,segment9 from
415: per_all_assignments_f paaf,
416: hr_soft_coding_keyflex hsck
417: where
418: paaf.assignment_id= p_ASG_id --20805
419: and paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id