APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 1985: pay_element_types_f petf ,

1981: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
1982: FROM pay_assignment_actions paa ,
1983: pay_run_results prr,
1984: pay_run_result_values prrv,
1985: pay_element_types_f petf ,
1986: pay_input_values_f pivf
1987: WHERE paa.source_action_id = p_last_asg_action_id
1988: AND paa.assignment_action_id = prr.assignment_action_id
1989: AND prr.element_type_id = petf.element_type_id

Line 2003: pay_element_types_f petf ,

1999: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
2000: FROM pay_assignment_actions paa ,
2001: pay_run_results prr,
2002: pay_run_result_values prrv,
2003: pay_element_types_f petf ,
2004: pay_input_values_f pivf
2005: WHERE paa.source_action_id = p_last_asg_action_id
2006: AND paa.assignment_action_id = prr.assignment_action_id
2007: AND prr.element_type_id = petf.element_type_id

Line 2766: pay_element_types_f petf ,

2762: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
2763: FROM pay_assignment_actions paa ,
2764: pay_run_results prr,
2765: pay_run_result_values prrv,
2766: pay_element_types_f petf ,
2767: pay_input_values_f pivf
2768: WHERE paa.source_action_id = p_last_asg_action_id
2769: AND paa.assignment_action_id = prr.assignment_action_id
2770: AND prr.element_type_id = petf.element_type_id

Line 2784: pay_element_types_f petf ,

2780: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
2781: FROM pay_assignment_actions paa ,
2782: pay_run_results prr,
2783: pay_run_result_values prrv,
2784: pay_element_types_f petf ,
2785: pay_input_values_f pivf
2786: WHERE paa.source_action_id = p_last_asg_action_id
2787: AND paa.assignment_action_id = prr.assignment_action_id
2788: AND prr.element_type_id = petf.element_type_id

Line 3567: pay_element_types_f petf ,

3563: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
3564: FROM pay_assignment_actions paa ,
3565: pay_run_results prr,
3566: pay_run_result_values prrv,
3567: pay_element_types_f petf ,
3568: pay_input_values_f pivf
3569: WHERE paa.source_action_id = p_last_asg_action_id
3570: AND paa.assignment_action_id = prr.assignment_action_id
3571: AND prr.element_type_id = petf.element_type_id

Line 3583: pay_element_types_f petf ,

3579: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
3580: FROM pay_assignment_actions paa ,
3581: pay_run_results prr,
3582: pay_run_result_values prrv,
3583: pay_element_types_f petf ,
3584: pay_input_values_f pivf
3585: WHERE paa.source_action_id = p_last_asg_action_id
3586: AND paa.assignment_action_id = prr.assignment_action_id
3587: AND prr.element_type_id = petf.element_type_id

Line 4245: pay_element_types_f petf ,

4241: SELECT MAX(DECODE(name,'Category',result_value,NULL))
4242: FROM pay_assignment_actions paa ,
4243: pay_run_results prr,
4244: pay_run_result_values prrv,
4245: pay_element_types_f petf ,
4246: pay_input_values_f pivf
4247: WHERE paa.source_action_id = f_asg_act_id
4248: AND paa.assignment_action_id = prr.assignment_action_id
4249: AND prr.element_type_id = petf.element_type_id

Line 4260: pay_element_types_f petf ,

4256: SELECT MAX(DECODE(name,'Category',result_value,NULL))
4257: FROM pay_assignment_actions paa ,
4258: pay_run_results prr,
4259: pay_run_result_values prrv,
4260: pay_element_types_f petf ,
4261: pay_input_values_f pivf
4262: WHERE paa.source_action_id = f_asg_act_id
4263: AND paa.assignment_action_id = prr.assignment_action_id
4264: AND prr.element_type_id = petf.element_type_id

Line 7954: FROM pay_element_types_f petf,

7950: CURSOR csr_ni_details
7951: IS
7952: SELECT petf.element_type_id,
7953: input_value_id
7954: FROM pay_element_types_f petf,
7955: pay_input_values_f pivf
7956: WHERE petf.element_name = 'NI'
7957: AND petf.element_type_id = pivf.element_type_id
7958: AND pivf.name = 'Process Type'

Line 8131: FROM pay_element_types_f

8127: hr_utility.trace('g_first_fps_run_date: '||g_first_fps_run_date);
8128:
8129: SELECT distinct element_type_id
8130: INTO g_paye_element_id
8131: FROM pay_element_types_f
8132: WHERE element_name = 'PAYE'
8133: AND legislation_code = 'GB';
8134:
8135: SELECT distinct element_type_id

Line 8137: FROM pay_element_types_f

8133: AND legislation_code = 'GB';
8134:
8135: SELECT distinct element_type_id
8136: INTO g_paye_details_id
8137: FROM pay_element_types_f
8138: WHERE element_name = 'PAYE Details'
8139: AND legislation_code = 'GB';
8140:
8141: SELECT distinct element_type_id

Line 8143: FROM pay_element_types_f

8139: AND legislation_code = 'GB';
8140:
8141: SELECT distinct element_type_id
8142: INTO g_adv_period_id
8143: FROM pay_element_types_f
8144: WHERE element_name = 'Advance Period'
8145: AND legislation_code = 'GB';
8146:
8147: hr_utility.trace('g_paye_element_id: '||TO_CHAR(g_paye_element_id));