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_TYPES_F

Line 263: l_element_type_id pay_element_types_f.element_type_id%TYPE;

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;
267: l_input_value_id4 pay_input_values_f.input_value_id%TYPE;

Line 292: pay_element_types_f et,

288: MIN(DECODE(iv.name, 'Date Returned', iv.input_value_id, null)) iv9,
289: MIN(DECODE(iv.name, 'Registration Date', iv.input_value_id, null)) iv10,
290: MIN(DECODE(iv.name, 'Lower Income Percentage', iv.input_value_id, null)) iv11
291: FROM
292: pay_element_types_f et,
293: pay_input_values_f iv
294: WHERE et.element_name = 'Tax Card'
295: AND et.legislation_code = 'FI'
296: AND et.business_group_id is null

Line 471: l_element_type_id pay_element_types_f.element_type_id%TYPE;

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;
475: l_input_value_id4 pay_input_values_f.input_value_id%TYPE;

Line 487: pay_element_types_f et,

483: MIN(DECODE(iv.name, 'Extra Income Additional Rate', iv.input_value_id, null)) iv3,
484: MIN(DECODE(iv.name, 'Extra Income Limit', iv.input_value_id, null)) iv4,
485: MIN(DECODE(iv.name, 'Previous Extra Income', iv.input_value_id, null)) iv5
486: FROM
487: pay_element_types_f et,
488: pay_input_values_f iv
489: WHERE et.element_name = 'Tax'
490: AND et.legislation_code = 'FI'
491: AND et.business_group_id is null

Line 510: l_element_name IN pay_element_types_f.element_name%TYPE,

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 ,
514: pay_element_links_f pel ,

Line 513: FROM pay_element_types_f pet ,

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 ,
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'

Line 1420: -- p_element_name Yes pay_element_types_f.element_name%TYPE Name of the Element to be checked.

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:
1424: -- The function returns the id of the element entry.

Line 1433: p_element_name IN pay_element_types_f.element_name%TYPE,

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
1437: l_attached_flag BOOLEAN;

Line 1441: l_element_name IN pay_element_types_f.element_name%TYPE,

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 ,
1445: pay_element_links_f pel ,

Line 1444: FROM pay_element_types_f pet ,

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 ,
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'

Line 1484: -- p_element_name Yes pay_element_types_f.element_name%TYPE Name of the Element to be checked.

1480: -- In Parameters:
1481: -- Name Reqd Type Description
1482: -- p_effective_date Yes VARCHAR2 The effective date of the change.
1483: -- p_assignment_id Yes per_all_assignments_f.assignment_id%TYPE ID of the assignment
1484: -- p_element_name Yes pay_element_types_f.element_name%TYPE Name of the Element to be checked.
1485: --
1486: --
1487: -- Post Success:
1488: -- The function returns true if the start date of the element is equals the effectived date

Line 1496: p_element_name IN pay_element_types_f.element_name%TYPE,

1492: --
1493: -- {End Of Comments}
1494: FUNCTION is_element_started_today (
1495: p_assignment_id IN pay_element_entries_f.assignment_id%TYPE,
1496: p_element_name IN pay_element_types_f.element_name%TYPE,
1497: p_effective_date IN VARCHAR2) RETURN BOOLEAN IS
1498:
1499: --declarations here
1500: Cursor cElementStartedToday(c_effective_date VARCHAR2, c_element_name pay_element_types_f.element_name%TYPE , c_asg_id per_all_assignments_f.assignment_id%TYPE) IS

Line 1500: Cursor cElementStartedToday(c_effective_date VARCHAR2, c_element_name pay_element_types_f.element_name%TYPE , c_asg_id per_all_assignments_f.assignment_id%TYPE) IS

1496: p_element_name IN pay_element_types_f.element_name%TYPE,
1497: p_effective_date IN VARCHAR2) RETURN BOOLEAN IS
1498:
1499: --declarations here
1500: Cursor cElementStartedToday(c_effective_date VARCHAR2, c_element_name pay_element_types_f.element_name%TYPE , c_asg_id per_all_assignments_f.assignment_id%TYPE) IS
1501: select pee.element_entry_id
1502: from pay_element_entries_f pee,
1503: pay_element_types_f pet
1504: where pee.element_type_id = pet.element_type_id

Line 1503: pay_element_types_f pet

1499: --declarations here
1500: Cursor cElementStartedToday(c_effective_date VARCHAR2, c_element_name pay_element_types_f.element_name%TYPE , c_asg_id per_all_assignments_f.assignment_id%TYPE) IS
1501: select pee.element_entry_id
1502: from pay_element_entries_f pee,
1503: pay_element_types_f pet
1504: where pee.element_type_id = pet.element_type_id
1505: and pet.element_name = c_element_name
1506: and c_effective_date between pet.effective_start_date and pet.effective_end_date
1507: and pee.assignment_id = c_asg_id

Line 1593: -- p_element_name Yes pay_element_types_f.element_name%TYPE Name of the Element to be checked.

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:
1597: -- The function returns true if the element is attached to the assignment and false otherwise.

Line 1606: p_element_name IN pay_element_types_f.element_name%TYPE,

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
1610: l_attached_flag BOOLEAN;

Line 1614: l_element_name IN pay_element_types_f.element_name%TYPE,

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 ,
1618: pay_element_links_f pel ,

Line 1617: FROM pay_element_types_f pet ,

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 ,
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'