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.PY_FI_TAX_CARD dependencies on PAY_ELEMENT_LINKS_F

Line 262: l_element_link_id pay_element_links_f.element_link_id%TYPE;

258: l_end_date DATE;
259: l_warning BOOLEAN;
260: l_element_entry_id NUMBER(15);
261: l_ovn NUMBER(9);
262: l_element_link_id pay_element_links_f.element_link_id%TYPE;
263: l_element_type_id pay_element_types_f.element_type_id%TYPE;
264: l_input_value_id1 pay_input_values_f.input_value_id%TYPE;
265: l_input_value_id2 pay_input_values_f.input_value_id%TYPE;
266: l_input_value_id3 pay_input_values_f.input_value_id%TYPE;

Line 470: l_element_link_id pay_element_links_f.element_link_id%TYPE;

466: l_end_date DATE;
467: l_warning BOOLEAN;
468: l_element_entry_id NUMBER(15);
469: l_ovn NUMBER(9);
470: l_element_link_id pay_element_links_f.element_link_id%TYPE;
471: l_element_type_id pay_element_types_f.element_type_id%TYPE;
472: l_input_value_id1 pay_input_values_f.input_value_id%TYPE;
473: l_input_value_id2 pay_input_values_f.input_value_id%TYPE;
474: l_input_value_id3 pay_input_values_f.input_value_id%TYPE;

Line 509: l_business_grp_id IN pay_element_links_f.business_group_id%TYPE,

505: and effective_date = p_effective_date;
506: LR_CHECK_FND_SESSION CSR_CHECK_FND_SESSION%ROWTYPE;
507:
508: CURSOR cIsElementAttached(l_asgid IN pay_element_entries_f.assignment_id%TYPE,
509: l_business_grp_id IN pay_element_links_f.business_group_id%TYPE,
510: l_element_name IN pay_element_types_f.element_name%TYPE,
511: l_effective_date IN VARCHAR2) IS
512: SELECT pee.element_entry_id,pee.OBJECT_VERSION_NUMBER EE_OVN
513: FROM pay_element_types_f pet ,

Line 514: pay_element_links_f pel ,

510: l_element_name IN pay_element_types_f.element_name%TYPE,
511: l_effective_date IN VARCHAR2) IS
512: SELECT pee.element_entry_id,pee.OBJECT_VERSION_NUMBER EE_OVN
513: FROM pay_element_types_f pet ,
514: pay_element_links_f pel ,
515: pay_element_entries_f pee
516: WHERE pet.element_name = l_element_name
517: AND pet.legislation_code = 'FI'
518: AND pet.business_group_id IS NULL

Line 1419: -- p_business_group_id Yes pay_element_links_f.business_group_id%TYPE Business Group Id.

1415: -- In Parameters:
1416: -- Name Reqd Type Description
1417: -- p_effective_date Yes VARCHAR2 The effective date of the change.
1418: -- p_assignment_id Yes per_all_assignments_f.assignment_id%TYPE ID of the assignment
1419: -- p_business_group_id Yes pay_element_links_f.business_group_id%TYPE Business Group Id.
1420: -- p_element_name Yes pay_element_types_f.element_name%TYPE Name of the Element to be checked.
1421: --
1422: --
1423: -- Post Success:

Line 1432: p_business_group_id IN pay_element_links_f.business_group_id%TYPE,

1428: --
1429: -- {End Of Comments}
1430: FUNCTION find_element_entry_id (
1431: p_assignment_id IN pay_element_entries_f.assignment_id%TYPE,
1432: p_business_group_id IN pay_element_links_f.business_group_id%TYPE,
1433: p_element_name IN pay_element_types_f.element_name%TYPE,
1434: p_effective_date IN VARCHAR2) RETURN pay_element_entries_f.element_entry_id%TYPE IS
1435:
1436: --declarations here

Line 1440: l_business_grp_id IN pay_element_links_f.business_group_id%TYPE,

1436: --declarations here
1437: l_attached_flag BOOLEAN;
1438: l_csr_result pay_element_entries_f.element_entry_id%TYPE;
1439: CURSOR cGetElementEntryId(l_asgid IN pay_element_entries_f.assignment_id%TYPE,
1440: l_business_grp_id IN pay_element_links_f.business_group_id%TYPE,
1441: l_element_name IN pay_element_types_f.element_name%TYPE,
1442: l_effective_date IN VARCHAR2) IS
1443: SELECT pee.element_entry_id
1444: FROM pay_element_types_f pet ,

Line 1445: pay_element_links_f pel ,

1441: l_element_name IN pay_element_types_f.element_name%TYPE,
1442: l_effective_date IN VARCHAR2) IS
1443: SELECT pee.element_entry_id
1444: FROM pay_element_types_f pet ,
1445: pay_element_links_f pel ,
1446: pay_element_entries_f pee
1447: WHERE pet.element_name = l_element_name
1448: AND pet.legislation_code = 'FI'
1449: AND pet.business_group_id IS NULL

Line 1592: -- p_business_group_id Yes pay_element_links_f.business_group_id%TYPE Business Group Id.

1588: -- In Parameters:
1589: -- Name Reqd Type Description
1590: -- p_effective_date Yes VARCHAR2 The effective date of the change.
1591: -- p_assignment_id Yes per_all_assignments_f.assignment_id%TYPE ID of the assignment
1592: -- p_business_group_id Yes pay_element_links_f.business_group_id%TYPE Business Group Id.
1593: -- p_element_name Yes pay_element_types_f.element_name%TYPE Name of the Element to be checked.
1594: --
1595: --
1596: -- Post Success:

Line 1605: p_business_group_id IN pay_element_links_f.business_group_id%TYPE,

1601: --
1602: -- {End Of Comments}
1603: FUNCTION is_element_attached (
1604: p_assignment_id IN pay_element_entries_f.assignment_id%TYPE,
1605: p_business_group_id IN pay_element_links_f.business_group_id%TYPE,
1606: p_element_name IN pay_element_types_f.element_name%TYPE,
1607: p_effective_date IN VARCHAR2) RETURN BOOLEAN IS
1608:
1609: --declarations here

Line 1613: l_business_grp_id IN pay_element_links_f.business_group_id%TYPE,

1609: --declarations here
1610: l_attached_flag BOOLEAN;
1611: l_csr_result pay_element_entries_f.element_entry_id%TYPE;
1612: CURSOR cIsElementAttached(l_asgid IN pay_element_entries_f.assignment_id%TYPE,
1613: l_business_grp_id IN pay_element_links_f.business_group_id%TYPE,
1614: l_element_name IN pay_element_types_f.element_name%TYPE,
1615: l_effective_date IN VARCHAR2) IS
1616: SELECT pee.element_entry_id
1617: FROM pay_element_types_f pet ,

Line 1618: pay_element_links_f pel ,

1614: l_element_name IN pay_element_types_f.element_name%TYPE,
1615: l_effective_date IN VARCHAR2) IS
1616: SELECT pee.element_entry_id
1617: FROM pay_element_types_f pet ,
1618: pay_element_links_f pel ,
1619: pay_element_entries_f pee
1620: WHERE pet.element_name = l_element_name
1621: AND pet.legislation_code = 'FI'
1622: AND pet.business_group_id IS NULL