eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 1986: pay_input_values_f pivf

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
1990: AND petf.element_name = 'NI DETAILS'

Line 2004: pay_input_values_f pivf

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
2008: AND petf.element_name = 'NI'

Line 2135: pay_input_values_f pivf

2131: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
2132: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
2133: from pay_element_entries_f peef,
2134: pay_element_entry_values_f peevf ,
2135: pay_input_values_f pivf
2136: where
2137: peef.assignment_id = p_person_rec.assignment_id
2138: and peef.ELEMENT_TYPE_ID = g_adv_period_id
2139: and peef.element_entry_id = peevf.element_entry_id

Line 2767: pay_input_values_f pivf

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
2771: AND petf.element_name = 'NI DETAILS'

Line 2785: pay_input_values_f pivf

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
2789: AND petf.element_name = 'NI'

Line 2911: pay_input_values_f pivf

2907: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
2908: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
2909: from pay_element_entries_f peef,
2910: pay_element_entry_values_f peevf ,
2911: pay_input_values_f pivf
2912: where
2913: peef.assignment_id = p_person_rec.assignment_id
2914: and peef.ELEMENT_TYPE_ID = g_adv_period_id
2915: and peef.element_entry_id = peevf.element_entry_id

Line 3568: pay_input_values_f pivf

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
3572: AND petf.element_name = 'NI DETAILS'

Line 3584: pay_input_values_f pivf

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
3588: AND petf.element_name = 'NI'

Line 3714: pay_input_values_f pivf

3710: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
3711: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
3712: from pay_element_entries_f peef,
3713: pay_element_entry_values_f peevf ,
3714: pay_input_values_f pivf
3715: where
3716: peef.assignment_id = l_asg_id
3717: and peef.ELEMENT_TYPE_ID = g_adv_period_id
3718: and peef.element_entry_id = peevf.element_entry_id

Line 4246: pay_input_values_f pivf

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
4250: AND petf.element_name = 'NI DETAILS'

Line 4261: pay_input_values_f pivf

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
4265: AND petf.element_name = 'NI'

Line 4401: FROM pay_input_values_f v,

4397:
4398: CURSOR csr_run_result(p_run_result_id number,p_element_type_id number) IS
4399: SELECT max(decode(name,'Tax Code',result_value,NULL)) tax_code,
4400: MAX(DECODE(name,'Tax Basis',DECODE(result_value,'N','Y',NULL),NULL)) tax_basis
4401: FROM pay_input_values_f v,
4402: pay_run_result_values rrv
4403: WHERE rrv.run_result_id = p_run_result_id
4404: AND v.input_value_id = rrv.input_value_id
4405: AND v.element_type_id = p_element_type_id;

Line 4563: pay_input_values_f iv,

4559: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)),
4560: decode(max(decode(iv.name,'Tax Basis',screen_entry_value)),'N','Y',NULL)
4561: FROM pay_element_entries_f e,
4562: pay_element_entry_values_f v,
4563: pay_input_values_f iv,
4564: pay_element_links_f link
4565: WHERE e.assignment_id = p_asg_id
4566: AND link.element_type_id = g_paye_details_id
4567: AND e.element_link_id = link.element_link_id

Line 4592: pay_input_values_f pivf

4588: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
4589: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
4590: FROM pay_run_results prr ,
4591: pay_run_result_values prrv ,
4592: pay_input_values_f pivf
4593: WHERE prr.assignment_action_id = p_action_id
4594: AND prr.ELEMENT_TYPE_ID = g_paye_element_id
4595: AND prrv.run_result_id = prr.run_result_id
4596: AND pivf.INPUT_VALUE_ID = prrv.INPUT_VALUE_ID;

Line 4836: pay_input_values_f iv,

4832: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)),
4833: decode(max(decode(iv.name,'Tax Basis',screen_entry_value)),'N','Y',NULL)
4834: FROM pay_element_entries_f e,
4835: pay_element_entry_values_f v,
4836: pay_input_values_f iv,
4837: pay_element_links_f link
4838: WHERE e.assignment_id = p_asg_id
4839: AND link.element_type_id = g_paye_details_id
4840: AND e.element_link_id = link.element_link_id

Line 4865: pay_input_values_f pivf

4861: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
4862: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
4863: FROM pay_run_results prr ,
4864: pay_run_result_values prrv ,
4865: pay_input_values_f pivf
4866: WHERE prr.assignment_action_id = p_action_id
4867: AND prr.ELEMENT_TYPE_ID = g_paye_element_id
4868: AND prrv.run_result_id = prr.run_result_id
4869: AND pivf.INPUT_VALUE_ID = prrv.INPUT_VALUE_ID;

Line 5093: pay_input_values_f pivf

5089: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
5090: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
5091: FROM pay_run_results prr ,
5092: pay_run_result_values prrv ,
5093: pay_input_values_f pivf
5094: WHERE prr.assignment_action_id = p_action_id
5095: AND prr.ELEMENT_TYPE_ID = g_paye_element_id
5096: AND prrv.run_result_id = prr.run_result_id
5097: AND pivf.INPUT_VALUE_ID = prrv.INPUT_VALUE_ID;

Line 5104: pay_input_values_f iv,

5100: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
5101: max(decode(iv.name,'Tax Basis',DECODE(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- kvinayku bug no 14774165
5102: FROM pay_element_entries_f e,
5103: pay_element_entry_values_f v,
5104: pay_input_values_f iv,
5105: pay_element_links_f link
5106: WHERE e.assignment_id = p_asg_id
5107: AND link.element_type_id = g_paye_details_id
5108: AND e.element_link_id = link.element_link_id

Line 5775: pay_input_values_f pivf

5771: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
5772: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
5773: FROM pay_run_results prr ,
5774: pay_run_result_values prrv ,
5775: pay_input_values_f pivf
5776: WHERE prr.assignment_action_id = p_action_id
5777: AND prr.ELEMENT_TYPE_ID = g_paye_element_id
5778: AND prrv.run_result_id = prr.run_result_id
5779: AND pivf.INPUT_VALUE_ID = prrv.INPUT_VALUE_ID;

Line 5786: pay_input_values_f iv,

5782: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
5783: max(decode(iv.name,'Tax Basis',decode(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- added by kvinayku 14774165
5784: FROM pay_element_entries_f e,
5785: pay_element_entry_values_f v,
5786: pay_input_values_f iv,
5787: pay_element_links_f link
5788: WHERE e.assignment_id = p_asg_id
5789: AND link.element_type_id = g_paye_details_id
5790: AND e.element_link_id = link.element_link_id

Line 7955: pay_input_values_f pivf

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'
7959: AND petf.legislation_code = 'GB'