APPS.PAY_GB_RTI_FPS dependencies on PAY_ELEMENT_TYPES_F

Line 1475: pay_element_types_f petf ,

1471: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
1472: FROM pay_assignment_actions paa ,
1473: pay_run_results prr,
1474: pay_run_result_values prrv,
1475: pay_element_types_f petf ,
1476: pay_input_values_f pivf
1477: WHERE paa.source_action_id = p_last_asg_action_id
1478: AND paa.assignment_action_id = prr.assignment_action_id
1479: AND prr.element_type_id = petf.element_type_id

Line 1493: pay_element_types_f petf ,

1489: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
1490: FROM pay_assignment_actions paa ,
1491: pay_run_results prr,
1492: pay_run_result_values prrv,
1493: pay_element_types_f petf ,
1494: pay_input_values_f pivf
1495: WHERE paa.source_action_id = p_last_asg_action_id
1496: AND paa.assignment_action_id = prr.assignment_action_id
1497: AND prr.element_type_id = petf.element_type_id

Line 2288: pay_element_types_f petf ,

2284: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
2285: FROM pay_assignment_actions paa ,
2286: pay_run_results prr,
2287: pay_run_result_values prrv,
2288: pay_element_types_f petf ,
2289: pay_input_values_f pivf
2290: WHERE paa.source_action_id = p_last_asg_action_id
2291: AND paa.assignment_action_id = prr.assignment_action_id
2292: AND prr.element_type_id = petf.element_type_id

Line 2306: pay_element_types_f petf ,

2302: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
2303: FROM pay_assignment_actions paa ,
2304: pay_run_results prr,
2305: pay_run_result_values prrv,
2306: pay_element_types_f petf ,
2307: pay_input_values_f pivf
2308: WHERE paa.source_action_id = p_last_asg_action_id
2309: AND paa.assignment_action_id = prr.assignment_action_id
2310: AND prr.element_type_id = petf.element_type_id

Line 3100: pay_element_types_f petf ,

3096: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
3097: FROM pay_assignment_actions paa ,
3098: pay_run_results prr,
3099: pay_run_result_values prrv,
3100: pay_element_types_f petf ,
3101: pay_input_values_f pivf
3102: WHERE paa.source_action_id = p_last_asg_action_id
3103: AND paa.assignment_action_id = prr.assignment_action_id
3104: AND prr.element_type_id = petf.element_type_id

Line 3116: pay_element_types_f petf ,

3112: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
3113: FROM pay_assignment_actions paa ,
3114: pay_run_results prr,
3115: pay_run_result_values prrv,
3116: pay_element_types_f petf ,
3117: pay_input_values_f pivf
3118: WHERE paa.source_action_id = p_last_asg_action_id
3119: AND paa.assignment_action_id = prr.assignment_action_id
3120: AND prr.element_type_id = petf.element_type_id

Line 7325: FROM pay_element_types_f petf,

7321: CURSOR csr_ni_details
7322: IS
7323: SELECT petf.element_type_id,
7324: input_value_id
7325: FROM pay_element_types_f petf,
7326: pay_input_values_f pivf
7327: WHERE petf.element_name = 'NI'
7328: AND petf.element_type_id = pivf.element_type_id
7329: AND pivf.name = 'Process Type'

Line 7502: FROM pay_element_types_f

7498: hr_utility.trace('g_first_fps_run_date: '||g_first_fps_run_date);
7499:
7500: SELECT distinct element_type_id
7501: INTO g_paye_element_id
7502: FROM pay_element_types_f
7503: WHERE element_name = 'PAYE'
7504: AND legislation_code = 'GB';
7505:
7506: SELECT distinct element_type_id

Line 7508: FROM pay_element_types_f

7504: AND legislation_code = 'GB';
7505:
7506: SELECT distinct element_type_id
7507: INTO g_paye_details_id
7508: FROM pay_element_types_f
7509: WHERE element_name = 'PAYE Details'
7510: AND legislation_code = 'GB';
7511:
7512: SELECT distinct element_type_id

Line 7514: FROM pay_element_types_f

7510: AND legislation_code = 'GB';
7511:
7512: SELECT distinct element_type_id
7513: INTO g_adv_period_id
7514: FROM pay_element_types_f
7515: WHERE element_name = 'Advance Period'
7516: AND legislation_code = 'GB';
7517:
7518: hr_utility.trace('g_paye_element_id: '||TO_CHAR(g_paye_element_id));