APPS.PAY_SE_GENERAL dependencies on PAY_RANGES_F

Line 32: l_amount1 PAY_RANGES_F.amount1%type;

28: RETURN Number
29: IS
30:
31:
32: l_amount1 PAY_RANGES_F.amount1%type;
33: l_amount2 PAY_RANGES_F.amount1%type;
34: l_amount3 PAY_RANGES_F.amount1%type;
35: l_amount4 PAY_RANGES_F.amount1%type;
36: l_amount5 PAY_RANGES_F.amount1%type;

Line 33: l_amount2 PAY_RANGES_F.amount1%type;

29: IS
30:
31:
32: l_amount1 PAY_RANGES_F.amount1%type;
33: l_amount2 PAY_RANGES_F.amount1%type;
34: l_amount3 PAY_RANGES_F.amount1%type;
35: l_amount4 PAY_RANGES_F.amount1%type;
36: l_amount5 PAY_RANGES_F.amount1%type;
37:

Line 34: l_amount3 PAY_RANGES_F.amount1%type;

30:
31:
32: l_amount1 PAY_RANGES_F.amount1%type;
33: l_amount2 PAY_RANGES_F.amount1%type;
34: l_amount3 PAY_RANGES_F.amount1%type;
35: l_amount4 PAY_RANGES_F.amount1%type;
36: l_amount5 PAY_RANGES_F.amount1%type;
37:
38: cursor csr_amount(ROM char,PERIOD Number,Tax_Base Number)

Line 35: l_amount4 PAY_RANGES_F.amount1%type;

31:
32: l_amount1 PAY_RANGES_F.amount1%type;
33: l_amount2 PAY_RANGES_F.amount1%type;
34: l_amount3 PAY_RANGES_F.amount1%type;
35: l_amount4 PAY_RANGES_F.amount1%type;
36: l_amount5 PAY_RANGES_F.amount1%type;
37:
38: cursor csr_amount(ROM char,PERIOD Number,Tax_Base Number)
39: is

Line 36: l_amount5 PAY_RANGES_F.amount1%type;

32: l_amount1 PAY_RANGES_F.amount1%type;
33: l_amount2 PAY_RANGES_F.amount1%type;
34: l_amount3 PAY_RANGES_F.amount1%type;
35: l_amount4 PAY_RANGES_F.amount1%type;
36: l_amount5 PAY_RANGES_F.amount1%type;
37:
38: cursor csr_amount(ROM char,PERIOD Number,Tax_Base Number)
39: is
40: select amount1,amount2,amount3,amount4,amount5

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