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_P45_PKG dependencies on FF_ARCHIVE_ITEMS

Line 1482: l_archive_item_id ff_archive_items.archive_item_id%TYPE;

1478: l_employers_name_eid ff_user_entities.user_entity_id%TYPE;
1479: l_employers_address_line_eid ff_user_entities.user_entity_id%TYPE;
1480: l_tax_district_name_eid ff_user_entities.user_entity_id%TYPE;
1481: -- vars for returns from the API:
1482: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
1483: l_ovn NUMBER;
1484: l_some_warning BOOLEAN;
1485: l_payroll_id NUMBER;
1486: l_chk_start_date DATE; -- BUG 5671777-11 to store start date

Line 1809: l_arc_period_of_service_id ff_archive_items.value%TYPE;

1805: p_mode in varchar2) RETURN BOOLEAN
1806: IS
1807: --
1808: l_p45_action_exists boolean := FALSE;
1809: l_arc_period_of_service_id ff_archive_items.value%TYPE;
1810: l_arc_tax_ref_transfer ff_archive_items.value%TYPE;
1811: --
1812: /*
1813: cursor csr_check_action(c_assignment_id in number) is

Line 1810: l_arc_tax_ref_transfer ff_archive_items.value%TYPE;

1806: IS
1807: --
1808: l_p45_action_exists boolean := FALSE;
1809: l_arc_period_of_service_id ff_archive_items.value%TYPE;
1810: l_arc_tax_ref_transfer ff_archive_items.value%TYPE;
1811: --
1812: /*
1813: cursor csr_check_action(c_assignment_id in number) is
1814: select

Line 1817: from ff_archive_items fai, -- of P45 report type

1813: cursor csr_check_action(c_assignment_id in number) is
1814: select
1815: max(decode(fai.user_entity_id,g_period_of_service_eid,fai.VALUE)) pos
1816: ,max(decode(fai.user_entity_id,g_tax_ref_transfer_eid,fai.VALUE)) tfr
1817: from ff_archive_items fai, -- of P45 report type
1818: pay_assignment_actions act,
1819: pay_payroll_actions ppa
1820: where ppa.report_type='P45'
1821: and ppa.report_qualifier='GB'

Line 1833: from ff_archive_items fai

1829: */
1830: cursor csr_check_action(c_assignment_id in number) is
1831: select max(decode(fai.user_entity_id,g_period_of_service_eid,fai.VALUE)) pos
1832: ,max(decode(fai.user_entity_id,g_tax_ref_transfer_eid,fai.VALUE)) tfr
1833: from ff_archive_items fai
1834: where fai.user_entity_id in (g_tax_ref_transfer_eid,g_period_of_service_eid)
1835: and fai.context1 = (select max(act.assignment_action_id)
1836: from pay_payroll_actions ppa,
1837: pay_assignment_actions act

Line 2196: l_archive_item_id ff_archive_items.archive_item_id%TYPE;

2192: l_range_person_on varchar2(3);
2193: rec_asg g_type_asg_rec;
2194: --
2195: -- vars for returns from the API:
2196: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
2197: l_ovn NUMBER;
2198: l_some_warning BOOLEAN;
2199: -- 5144323: To store ids of assignments included on the P45
2200: TYPE l_included_asg_tab_type IS TABLE OF NUMBER

Line 3121: l_archive_item_id ff_archive_items.archive_item_id%TYPE;

3117: IS
3118: --
3119: l_proc CONSTANT VARCHAR2(35):= g_package||'archive_code';
3120: -- vars for returns from the API:
3121: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
3122: l_ovn NUMBER;
3123: l_some_warning BOOLEAN;
3124: --
3125: l_assignment_id per_assignments_f.assignment_id%TYPE;

Line 4318: ff_archive_items fai

4314: FROM pay_payroll_actions pact,
4315: pay_assignment_actions act,
4316: per_assignments_f paf,
4317: pay_action_interlocks pai,
4318: ff_archive_items fai
4319: WHERE pact.report_type ='P45'
4320: AND pact.report_qualifier ='GB'
4321: AND pact.report_category ='P45'
4322: AND pact.action_status = 'C'

Line 4373: index(fai FF_ARCHIVE_ITEMS_N50)*/

4369: SELECT /*+ordered
4370: index(pact PAY_PAYROLL_ACTIONS_N52)
4371: index(ppr PAY_POPULATION_RANGES_N4)
4372: index(act PAY_ASSIGNMENT_ACTIONS_N51)
4373: index(fai FF_ARCHIVE_ITEMS_N50)*/
4374: DISTINCT
4375: act.assignment_action_id archive_action,
4376: act.assignment_id
4377: from pay_payroll_actions pact,

Line 4381: ff_archive_items fai

4377: from pay_payroll_actions pact,
4378: pay_population_ranges ppr,
4379: per_assignments_f paf,
4380: pay_assignment_actions act,
4381: ff_archive_items fai
4382: WHERE pact.report_type ='P45'
4383: AND pact.report_qualifier ='GB'
4384: AND pact.report_category ='P45'
4385: AND pact.action_status = 'C'

Line 4591: from ff_archive_items fai,

4587: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_DATE_OF_BIRTH',fai.VALUE))),'DD-MM-YYYY'),4,2),' ') DATE_OF_BIRTH_MM,
4588: nvl(substr(to_char(fnd_date.canonical_to_date(max(decode(fue.user_entity_name,'X_DATE_OF_BIRTH',fai.VALUE))),'DD-MM-YYYY'),7,4),' ') DATE_OF_BIRTH_YY,
4589: nvl(max (decode(fue.user_entity_name,'X_SEX', substr(fai.value,1,1))),' ') SEX
4590: /*P45 A4 2008/09*/
4591: from ff_archive_items fai,
4592: ff_user_entities fue
4593: where x_assignment_action_id = fai.context1
4594: and fai.archive_type <>'PA'
4595: and fai.user_entity_id = fue.user_entity_id;

Line 4693: ff_archive_items fai,

4689: cursor cur_get_pact_archive_items is
4690: select upper(nvl(max(decode(fue.user_entity_name,'X_EMPLOYERS_NAME',fai.VALUE)),null)) EMPLOYERS_NAME,
4691: upper(nvl(max(decode(fue.user_entity_name,'X_EMPLOYERS_ADDRESS_LINE',fai.VALUE)),null)) EMPLOYERS_ADDRESS
4692: from ff_archive_item_contexts aic,
4693: ff_archive_items fai,
4694: ff_user_entities fue
4695: where X_PAYROLL_ACTION_ID = fai.context1
4696: and fai.user_entity_id = fue.user_entity_id
4697: and fai.archive_item_id = aic.archive_item_id

Line 4737: FROM ff_archive_items fai, ff_user_entities fue

4733: AND report_category = 'P45';
4734:
4735: CURSOR csr_transfer_p45(c_assignment_action_id NUMBER) IS
4736: SELECT fai.VALUE
4737: FROM ff_archive_items fai, ff_user_entities fue
4738: WHERE fai.user_entity_id = fue.user_entity_id
4739: AND fue.user_entity_name = 'X_TAX_REF_TRANSFER'
4740: AND fue.legislation_code = 'GB'
4741: AND fue.business_group_id IS NULL

Line 4744: l_transfer_flag ff_archive_items.value%type;

4740: AND fue.legislation_code = 'GB'
4741: AND fue.business_group_id IS NULL
4742: AND fai.context1 = c_assignment_action_id ;
4743:
4744: l_transfer_flag ff_archive_items.value%type;
4745: --
4746: BEGIN
4747: --
4748: open csr_get_p45_action(p_assignment_id);

Line 4815: from FF_ARCHIVE_ITEMS ai,

4811:
4812: /*
4813: Cursor csr_get_final_payment(c_assignment_id NUMBER, c_asg_action_id NUMBER, c_action_sequence NUMBER) IS
4814: select pact1.payroll_action_id, pact1.effective_date final_payment_date
4815: from FF_ARCHIVE_ITEMS ai,
4816: ff_user_entities ue,
4817: pay_payroll_actions pact1
4818: WHERE ue.user_entity_name in ('X_MONTH_NUMBER', 'X_WEEK_NUMBER') -- for the weekly frequency (and multiples)
4819: AND ue.legislation_code = 'GB'

Line 4911: from ff_archive_items fai,

4907: -- fetch P45 for another assignment that included the given assignment.
4908: --
4909: cursor csr_get_p45_another_asg(c_assignment_id number,c_assignment_action_id number) is
4910: select 1
4911: from ff_archive_items fai,
4912: ff_user_entities fue
4913: where fai.user_entity_id = fue.user_entity_id
4914: and fue.user_entity_name = 'X_P45_INCLUDED_ASSIGNMENT'
4915: and fai.context1 = c_assignment_action_id