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 PER_ALL_ASSIGNMENTS_F

Line 86: l_primary_asg_id per_all_assignments_f.assignment_id%TYPE;

82: ,p_prev_extra_income IN NUMBER DEFAULT NULL
83: ) IS
84: -- declarations here
85: l_proc varchar2(72) := g_package||'ins.';
86: l_primary_asg_id per_all_assignments_f.assignment_id%TYPE;
87:
88: CURSOR cPrimaryAsg(asgid IN per_all_assignments_f.assignment_id%TYPE,
89: effective_date IN DATE) IS
90: SELECT

Line 88: CURSOR cPrimaryAsg(asgid IN per_all_assignments_f.assignment_id%TYPE,

84: -- declarations here
85: l_proc varchar2(72) := g_package||'ins.';
86: l_primary_asg_id per_all_assignments_f.assignment_id%TYPE;
87:
88: CURSOR cPrimaryAsg(asgid IN per_all_assignments_f.assignment_id%TYPE,
89: effective_date IN DATE) IS
90: SELECT
91: pasg.assignment_id
92: FROM

Line 93: per_all_assignments_f pasg,

89: effective_date IN DATE) IS
90: SELECT
91: pasg.assignment_id
92: FROM
93: per_all_assignments_f pasg,
94: per_all_assignments_f asg
95: WHERE asg.assignment_id = asgid
96: AND fnd_date.canonical_to_date(effective_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
97: AND pasg.person_id = asg.person_id

Line 94: per_all_assignments_f asg

90: SELECT
91: pasg.assignment_id
92: FROM
93: per_all_assignments_f pasg,
94: per_all_assignments_f asg
95: WHERE asg.assignment_id = asgid
96: AND fnd_date.canonical_to_date(effective_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
97: AND pasg.person_id = asg.person_id
98: AND pasg.primary_flag = 'Y'

Line 840: l_primary_asg_id per_all_assignments_f.assignment_id%TYPE;

836: ,p_object_version_number_t IN VARCHAR2 DEFAULT NULL
837: ) IS
838: --declarations here
839: l_proc varchar2(72) := g_package||'upd.';
840: l_primary_asg_id per_all_assignments_f.assignment_id%TYPE;
841:
842: CURSOR cPrimaryAsg(asgid IN per_all_assignments_f.assignment_id%TYPE,
843: effective_date IN VARCHAR2) IS
844: SELECT

Line 842: CURSOR cPrimaryAsg(asgid IN per_all_assignments_f.assignment_id%TYPE,

838: --declarations here
839: l_proc varchar2(72) := g_package||'upd.';
840: l_primary_asg_id per_all_assignments_f.assignment_id%TYPE;
841:
842: CURSOR cPrimaryAsg(asgid IN per_all_assignments_f.assignment_id%TYPE,
843: effective_date IN VARCHAR2) IS
844: SELECT
845: pasg.assignment_id
846: FROM

Line 847: per_all_assignments_f pasg,

843: effective_date IN VARCHAR2) IS
844: SELECT
845: pasg.assignment_id
846: FROM
847: per_all_assignments_f pasg,
848: per_all_assignments_f asg
849: WHERE asg.assignment_id = asgid
850: AND fnd_date.canonical_to_date(effective_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
851: AND pasg.person_id = asg.person_id

Line 848: per_all_assignments_f asg

844: SELECT
845: pasg.assignment_id
846: FROM
847: per_all_assignments_f pasg,
848: per_all_assignments_f asg
849: WHERE asg.assignment_id = asgid
850: AND fnd_date.canonical_to_date(effective_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
851: AND pasg.person_id = asg.person_id
852: AND pasg.primary_flag = 'Y'

Line 1418: -- p_assignment_id Yes per_all_assignments_f.assignment_id%TYPE ID of the assignment

1414: --
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: --

Line 1483: -- p_assignment_id Yes per_all_assignments_f.assignment_id%TYPE ID of the assignment

1479: --
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:

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 1538: -- p_assignment_id Yes per_all_assignments_f.assignment_id%TYPE ID of the assignment

1534: --
1535: -- In Parameters:
1536: -- Name Reqd Type Description
1537: -- p_effective_date Yes VARCHAR2 The effective date of the change.
1538: -- p_assignment_id Yes per_all_assignments_f.assignment_id%TYPE ID of the assignment
1539: --
1540: --
1541: -- Post Success:
1542: -- The function returns true if the assignment is Primary and false otherwise

Line 1549: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1545: -- Private. For Internal Development Use only.
1546: --
1547: -- {End Of Comments}
1548: FUNCTION is_primary_asg (
1549: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1550: p_effective_date IN VARCHAR2) RETURN BOOLEAN IS
1551:
1552: --declarations here
1553: l_primary_flag BOOLEAN;

Line 1554: l_csr_result per_all_assignments_f.primary_flag%TYPE;

1550: p_effective_date IN VARCHAR2) RETURN BOOLEAN IS
1551:
1552: --declarations here
1553: l_primary_flag BOOLEAN;
1554: l_csr_result per_all_assignments_f.primary_flag%TYPE;
1555: CURSOR cIsPrimaryAsg(asgid IN per_all_assignments_f.assignment_id%TYPE,
1556: effective_date IN VARCHAR2) IS
1557: SELECT asg.primary_flag
1558: FROM per_all_assignments_f asg

Line 1555: CURSOR cIsPrimaryAsg(asgid IN per_all_assignments_f.assignment_id%TYPE,

1551:
1552: --declarations here
1553: l_primary_flag BOOLEAN;
1554: l_csr_result per_all_assignments_f.primary_flag%TYPE;
1555: CURSOR cIsPrimaryAsg(asgid IN per_all_assignments_f.assignment_id%TYPE,
1556: effective_date IN VARCHAR2) IS
1557: SELECT asg.primary_flag
1558: FROM per_all_assignments_f asg
1559: WHERE asg.assignment_id = asgid

Line 1558: FROM per_all_assignments_f asg

1554: l_csr_result per_all_assignments_f.primary_flag%TYPE;
1555: CURSOR cIsPrimaryAsg(asgid IN per_all_assignments_f.assignment_id%TYPE,
1556: effective_date IN VARCHAR2) IS
1557: SELECT asg.primary_flag
1558: FROM per_all_assignments_f asg
1559: WHERE asg.assignment_id = asgid
1560: AND fnd_date.chardate_to_date(effective_date) BETWEEN
1561: asg.effective_start_date AND asg.effective_end_date;
1562: BEGIN

Line 1591: -- p_assignment_id Yes per_all_assignments_f.assignment_id%TYPE ID of the assignment

1587: --
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: --