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_SG_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 207: FROM pay_payroll_actions PACT,

203:
204: ELSIF p_dimension_name like '%FQTD' THEN
205: SELECT fnd_date.canonical_to_date(org_information11)
206: INTO l_beg_of_fiscal_year
207: FROM pay_payroll_actions PACT,
208: hr_organization_information HOI
209: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
210: AND HOI.organization_id = PACT.business_group_id
211: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 219: FROM pay_payroll_actions PACT,

215:
216: ELSIF p_dimension_name like '%FYTD' THEN
217: SELECT fnd_date.canonical_to_date(org_information11)
218: INTO l_beg_of_fiscal_year
219: FROM pay_payroll_actions PACT,
220: hr_organization_information HOI
221: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
222: AND HOI.organization_id = PACT.business_group_id
223: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 325: FROM pay_payroll_actions PACT,

321:
322: ELSIF p_dimension_name like '%FQTD' THEN
323: SELECT fnd_date.canonical_to_date(org_information11)
324: INTO l_beg_of_fiscal_year
325: FROM pay_payroll_actions PACT,
326: hr_organization_information HOI
327: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
328: AND HOI.organization_id = PACT.business_group_id
329: AND PACT.payroll_action_id = p_owner_payroll_action_id;

Line 338: FROM pay_payroll_actions PACT,

334:
335: ELSIF p_dimension_name like '%FYTD' THEN
336: SELECT fnd_date.canonical_to_date(org_information11)
337: INTO l_beg_of_fiscal_year
338: FROM pay_payroll_actions PACT,
339: hr_organization_information HOI
340: WHERE UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
341:
342: AND HOI.organization_id = PACT.business_group_id

Line 396: FROM pay_payroll_actions ppa, pay_assignment_actions paa

392: AND pdb.defined_balance_id = c_defined_balance_id;
393:
394: cursor pact_effective_date( c_assignment_action_id in number ) is
395: SELECT ppa.payroll_action_id, ppa.effective_date
396: FROM pay_payroll_actions ppa, pay_assignment_actions paa
397: WHERE ppa.payroll_action_id = paa.payroll_action_id
398: AND paa.assignment_action_id = c_assignment_action_id;
399:
400: BEGIN

Line 429: FROM pay_payroll_actions PACT,

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

Line 440: FROM pay_payroll_actions PACT,

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