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 dependencies on PAY_INPUT_VALUES_F

Line 1476: pay_input_values_f pivf

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

Line 1494: pay_input_values_f pivf

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

Line 1630: pay_input_values_f pivf

1626: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
1627: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
1628: from pay_element_entries_f peef,
1629: pay_element_entry_values_f peevf ,
1630: pay_input_values_f pivf
1631: where
1632: peef.assignment_id = p_person_rec.assignment_id
1633: and peef.ELEMENT_TYPE_ID = g_adv_period_id
1634: and peef.element_entry_id = peevf.element_entry_id

Line 2289: pay_input_values_f pivf

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

Line 2307: pay_input_values_f pivf

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

Line 2438: pay_input_values_f pivf

2434: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
2435: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
2436: from pay_element_entries_f peef,
2437: pay_element_entry_values_f peevf ,
2438: pay_input_values_f pivf
2439: where
2440: peef.assignment_id = p_person_rec.assignment_id
2441: and peef.ELEMENT_TYPE_ID = g_adv_period_id
2442: and peef.element_entry_id = peevf.element_entry_id

Line 3101: pay_input_values_f pivf

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

Line 3117: pay_input_values_f pivf

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

Line 3252: pay_input_values_f pivf

3248: select fnd_date.canonical_to_date(max(decode(pivf.name,'Start Date',peevf.screen_entry_value,null))) start_date,
3249: fnd_date.canonical_to_date(max(decode(pivf.name,'End Date',peevf.screen_entry_value,null))) end_date
3250: from pay_element_entries_f peef,
3251: pay_element_entry_values_f peevf ,
3252: pay_input_values_f pivf
3253: where
3254: peef.assignment_id = l_asg_id
3255: and peef.ELEMENT_TYPE_ID = g_adv_period_id
3256: and peef.element_entry_id = peevf.element_entry_id

Line 3829: FROM pay_input_values_f v,

3825:
3826: CURSOR csr_run_result(p_run_result_id number,p_element_type_id number) IS
3827: SELECT max(decode(name,'Tax Code',result_value,NULL)) tax_code,
3828: MAX(DECODE(name,'Tax Basis',DECODE(result_value,'N','Y',NULL),NULL)) tax_basis
3829: FROM pay_input_values_f v,
3830: pay_run_result_values rrv
3831: WHERE rrv.run_result_id = p_run_result_id
3832: AND v.input_value_id = rrv.input_value_id
3833: AND v.element_type_id = p_element_type_id;

Line 3987: pay_input_values_f iv,

3983: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)),
3984: decode(max(decode(iv.name,'Tax Basis',screen_entry_value)),'N','Y',NULL)
3985: FROM pay_element_entries_f e,
3986: pay_element_entry_values_f v,
3987: pay_input_values_f iv,
3988: pay_element_links_f link
3989: WHERE e.assignment_id = p_asg_id
3990: AND link.element_type_id = g_paye_details_id
3991: AND e.element_link_id = link.element_link_id

Line 4016: pay_input_values_f pivf

4012: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
4013: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
4014: FROM pay_run_results prr ,
4015: pay_run_result_values prrv ,
4016: pay_input_values_f pivf
4017: WHERE prr.assignment_action_id = p_action_id
4018: AND prr.ELEMENT_TYPE_ID = g_paye_element_id
4019: AND prrv.run_result_id = prr.run_result_id
4020: AND pivf.INPUT_VALUE_ID = prrv.INPUT_VALUE_ID;

Line 4249: pay_input_values_f iv,

4245: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)),
4246: decode(max(decode(iv.name,'Tax Basis',screen_entry_value)),'N','Y',NULL)
4247: FROM pay_element_entries_f e,
4248: pay_element_entry_values_f v,
4249: pay_input_values_f iv,
4250: pay_element_links_f link
4251: WHERE e.assignment_id = p_asg_id
4252: AND link.element_type_id = g_paye_details_id
4253: AND e.element_link_id = link.element_link_id

Line 4278: pay_input_values_f pivf

4274: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
4275: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
4276: FROM pay_run_results prr ,
4277: pay_run_result_values prrv ,
4278: pay_input_values_f pivf
4279: WHERE prr.assignment_action_id = p_action_id
4280: AND prr.ELEMENT_TYPE_ID = g_paye_element_id
4281: AND prrv.run_result_id = prr.run_result_id
4282: AND pivf.INPUT_VALUE_ID = prrv.INPUT_VALUE_ID;

Line 4495: pay_input_values_f pivf

4491: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
4492: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
4493: FROM pay_run_results prr ,
4494: pay_run_result_values prrv ,
4495: pay_input_values_f pivf
4496: WHERE prr.assignment_action_id = p_action_id
4497: AND prr.ELEMENT_TYPE_ID = g_paye_element_id
4498: AND prrv.run_result_id = prr.run_result_id
4499: AND pivf.INPUT_VALUE_ID = prrv.INPUT_VALUE_ID;

Line 4506: pay_input_values_f iv,

4502: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
4503: max(decode(iv.name,'Tax Basis',DECODE(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- kvinayku bug no 14774165
4504: FROM pay_element_entries_f e,
4505: pay_element_entry_values_f v,
4506: pay_input_values_f iv,
4507: pay_element_links_f link
4508: WHERE e.assignment_id = p_asg_id
4509: AND link.element_type_id = g_paye_details_id
4510: AND e.element_link_id = link.element_link_id

Line 5161: pay_input_values_f pivf

5157: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
5158: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
5159: FROM pay_run_results prr ,
5160: pay_run_result_values prrv ,
5161: pay_input_values_f pivf
5162: WHERE prr.assignment_action_id = p_action_id
5163: AND prr.ELEMENT_TYPE_ID = g_paye_element_id
5164: AND prrv.run_result_id = prr.run_result_id
5165: AND pivf.INPUT_VALUE_ID = prrv.INPUT_VALUE_ID;

Line 5172: pay_input_values_f iv,

5168: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
5169: max(decode(iv.name,'Tax Basis',decode(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- added by kvinayku 14774165
5170: FROM pay_element_entries_f e,
5171: pay_element_entry_values_f v,
5172: pay_input_values_f iv,
5173: pay_element_links_f link
5174: WHERE e.assignment_id = p_asg_id
5175: AND link.element_type_id = g_paye_details_id
5176: AND e.element_link_id = link.element_link_id

Line 7326: pay_input_values_f pivf

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