DBA Data[Home] [Help]

APPS.PAY_SE_GENERAL dependencies on PAY_RANGE_TABLES_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