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_HK_EXC dependencies on PAY_PAYROLL_ACTIONS

Line 43: pay_payroll_actions PACT

39: BEGIN
40: select TP.end_date + 1
41: into l_return_val
42: from per_time_periods TP,
43: pay_payroll_actions PACT
44: where PACT.payroll_action_id = p_pactid
45: and PACT.payroll_id = TP.payroll_id
46: and p_date between TP.start_date and TP.end_date;
47:

Line 70: pay_payroll_actions PACT

66: BEGIN
67: select TP.end_date + 1
68: into l_return_val
69: from per_time_periods TP,
70: pay_payroll_actions PACT
71: where PACT.payroll_action_id = p_pactid
72: and PACT.payroll_id = TP.payroll_id
73: and PACT.date_earned between TP.start_date and TP.end_date;
74:

Line 113: from pay_payroll_actions PACT

109: l_return_val DATE := NULL;
110: BEGIN
111: select trunc(add_months(PACT.date_earned,1),'MM')
112: into l_return_val
113: from pay_payroll_actions PACT
114: where PACT.payroll_action_id = p_pactid;
115:
116: RETURN l_return_val;
117:

Line 156: from pay_payroll_actions PACT

152: l_return_val DATE := NULL;
153: BEGIN
154: select trunc(add_months(PACT.date_earned,3),'Q')
155: into l_return_val
156: from pay_payroll_actions PACT
157: where PACT.payroll_action_id = p_pactid;
158:
159: RETURN l_return_val;
160:

Line 286: FROM pay_payroll_actions PACT

282: to_char(PACT.date_earned,'YYYY'))+ decode(sign(PACT.date_earned
283: - to_date('01-04-'||to_char(PACT.date_earned,'YYYY'),'DD-MM-YYYY'))
284: ,-1,0,1)),'DD-MM-YYYY')
285: INTO l_expiry_date
286: FROM pay_payroll_actions PACT
287: WHERE PACT.payroll_action_id = p_owner_payroll_action_id;
288:
289: ELSIF p_dimension_name like '%PTD' THEN
290: l_expiry_date := next_period(p_owner_payroll_action_id,

Line 299: FROM pay_payroll_actions PACT,

295:
296: ELSIF p_dimension_name like '%FQTD' THEN
297: SELECT fnd_date.canonical_to_date(org_information11)
298: INTO l_beg_of_fiscal_year
299: FROM pay_payroll_actions PACT,
300: hr_organization_information HOI
301: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
302: AND HOI.organization_id = PACT.business_group_id
303: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 311: FROM pay_payroll_actions PACT,

307:
308: ELSIF p_dimension_name like '%FYTD' THEN
309: SELECT fnd_date.canonical_to_date(org_information11)
310: INTO l_beg_of_fiscal_year
311: FROM pay_payroll_actions PACT,
312: hr_organization_information HOI
313: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
314: AND HOI.organization_id = PACT.business_group_id
315: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 332: FROM pay_payroll_actions PACT

328: to_char(PACT.effective_date,'YYYY'))+ decode(sign(PACT.effective_date
329: - to_date('01-04-'||to_char(PACT.effective_date,'YYYY'),'DD-MM-YYYY'))
330: ,-1,0,1)),'DD-MM-YYYY')
331: INTO l_expiry_date
332: FROM pay_payroll_actions PACT
333: WHERE PACT.payroll_action_id = p_owner_payroll_action_id;
334:
335: ELSIF p_dimension_name like '%LTD' THEN
336: p_expiry_information := 0;

Line 376: FROM pay_payroll_actions ppa, pay_assignment_actions paa

372: AND pdb.defined_balance_id = c_defined_balance_id;
373:
374: cursor pact_effective_date( c_assignment_action_id in number ) is
375: SELECT ppa.payroll_action_id, ppa.effective_date
376: FROM pay_payroll_actions ppa, pay_assignment_actions paa
377: WHERE ppa.payroll_action_id = paa.payroll_action_id
378: AND paa.assignment_action_id = c_assignment_action_id;
379:
380: BEGIN

Line 415: FROM pay_payroll_actions PACT

411: to_char(PACT.date_earned,'YYYY'))+ decode(sign(PACT.date_earned
412: - to_date('01-04-'||to_char(PACT.date_earned,'YYYY'),'DD-MM-YYYY'))
413: ,-1,0,1)),'DD-MM-YYYY')
414: INTO l_beg_of_tax_year
415: FROM pay_payroll_actions PACT
416: WHERE PACT.payroll_action_id = l_payroll_action_id;
417:
418: RETURN l_beg_of_tax_year - 1;
419:

Line 431: FROM pay_payroll_actions PACT,

427:
428: ELSIF l_dimension_name like '%FQTD' THEN
429: SELECT fnd_date.canonical_to_date(org_information11)
430: INTO l_beg_of_fiscal_year
431: FROM pay_payroll_actions PACT,
432: hr_organization_information HOI
433: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
434: AND HOI.organization_id = PACT.business_group_id
435: AND PACT.payroll_action_id = l_payroll_action_id;

Line 442: FROM pay_payroll_actions PACT,

438:
439: ELSIF l_dimension_name like '%FYTD' THEN
440: SELECT fnd_date.canonical_to_date(org_information11)
441: INTO l_beg_of_fiscal_year
442: FROM pay_payroll_actions PACT,
443: hr_organization_information HOI
444: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
445: AND HOI.organization_id = PACT.business_group_id
446: AND PACT.payroll_action_id = l_payroll_action_id;

Line 462: FROM pay_payroll_actions PACT

458: to_char(PACT.effective_date,'YYYY'))+ decode(sign(PACT.effective_date
459: - to_date('01-04-'||to_char(PACT.effective_date,'YYYY'),'DD-MM-YYYY'))
460: ,-1,0,1)),'DD-MM-YYYY')
461: INTO l_beg_of_tax_year
462: FROM pay_payroll_actions PACT
463: WHERE PACT.payroll_action_id = l_payroll_action_id;
464:
465: RETURN l_beg_of_tax_year - 1;
466:

Line 561: FROM pay_payroll_actions PACT

557: to_char(PACT.date_earned,'YYYY'))+ decode(sign(PACT.date_earned
558: - to_date('01-04-'||to_char(PACT.date_earned,'YYYY'),'DD-MM-YYYY'))
559: ,-1,0,1)),'DD-MM-YYYY') - 1
560: INTO p_expiry_date
561: FROM pay_payroll_actions PACT
562: WHERE PACT.payroll_action_id = p_owner_payroll_action_id;
563: hr_utility.trace('p_expiry_date ===>' || p_expiry_date);
564:
565: ELSIF p_dimension_name like '%PTD' THEN

Line 576: FROM pay_payroll_actions PACT,

572:
573: ELSIF p_dimension_name like '%FQTD' THEN
574: SELECT fnd_date.canonical_to_date(org_information11)
575: INTO l_beg_of_fiscal_year
576: FROM pay_payroll_actions PACT,
577: hr_organization_information HOI
578: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
579: AND HOI.organization_id = PACT.business_group_id
580: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 587: FROM pay_payroll_actions PACT,

583:
584: ELSIF p_dimension_name like '%FYTD' THEN
585: SELECT fnd_date.canonical_to_date(org_information11)
586: INTO l_beg_of_fiscal_year
587: FROM pay_payroll_actions PACT,
588: hr_organization_information HOI
589: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
590: AND HOI.organization_id = PACT.business_group_id
591: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 610: FROM pay_payroll_actions PACT

606: to_char(PACT.effective_date,'YYYY'))+ decode(sign(PACT.effective_date
607: - to_date('01-04-'||to_char(PACT.effective_date,'YYYY'),'DD-MM-YYYY'))
608: ,-1,0,1)),'DD-MM-YYYY') - 1
609: INTO p_expiry_date
610: FROM pay_payroll_actions PACT
611: WHERE PACT.payroll_action_id = p_owner_payroll_action_id;
612:
613: ELSIF p_dimension_name like '%LTD' THEN
614: p_expiry_date := fnd_date.canonical_to_date('4712/12/31');

Line 663: pay_payroll_actions ppa,

659: CURSOR get_date_earned
660: IS
661: SELECT ppa.date_earned,paa.assignment_id
662: FROM
663: pay_payroll_actions ppa,
664: pay_assignment_actions paa
665: WHERE paa.assignment_action_id = p_asg_action
666: AND ppa.payroll_action_id=paa.payroll_action_id;
667: