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_CA_EOY_RL2_AMEND_REG dependencies on PAY_CA_EOY_RL1_AMEND_REG

Line 58: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

54: ,p_report_type out nocopy varchar2
55: )
56: IS
57: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
58: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
59: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
60: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
61: 'PER_ID',ppa.legislative_parameters)),
62: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

Line 60: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

56: IS
57: cursor c_payroll_Action_info (cp_payroll_action_id in number) is
58: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
59: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
60: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
61: 'PER_ID',ppa.legislative_parameters)),
62: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
63: 'ASG_SET_ID',ppa.legislative_parameters)),
64: pay_ca_eoy_rl1_amend_reg.get_parameter(

Line 62: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(

58: select to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
59: 'PRE_ORGANIZATION_ID',ppa.legislative_parameters)),
60: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
61: 'PER_ID',ppa.legislative_parameters)),
62: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
63: 'ASG_SET_ID',ppa.legislative_parameters)),
64: pay_ca_eoy_rl1_amend_reg.get_parameter(
65: 'MODE',ppa.legislative_parameters),
66: effective_date,

Line 64: pay_ca_eoy_rl1_amend_reg.get_parameter(

60: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
61: 'PER_ID',ppa.legislative_parameters)),
62: to_number(pay_ca_eoy_rl1_amend_reg.get_parameter(
63: 'ASG_SET_ID',ppa.legislative_parameters)),
64: pay_ca_eoy_rl1_amend_reg.get_parameter(
65: 'MODE',ppa.legislative_parameters),
66: effective_date,
67: start_date,
68: business_group_id,

Line 293: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

289: and cp_end_person
290: and ppa_arch.business_group_id = ln_business_group_id
291: and ppa_arch.report_type = 'CAEOY_RL2_AMEND_PP'
292: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
293: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
294: ppa_arch.legislative_parameters) =
295: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
296: ppa_arch.legislative_parameters))
297: and paa_arch.action_status = 'C'

Line 295: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

291: and ppa_arch.report_type = 'CAEOY_RL2_AMEND_PP'
292: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
293: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
294: ppa_arch.legislative_parameters) =
295: nvl(ln_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
296: ppa_arch.legislative_parameters))
297: and paa_arch.action_status = 'C'
298: and ppa_arch.effective_date = cp_effective_date
299: and paf.person_id = to_number(paa_arch.serial_number);

Line 358: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

354: ,cp_business_group_id in number) is
355: select ppa.report_type,
356: paa.assignment_id,
357: paa.assignment_action_id,
358: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
359: ppa.legislative_parameters)
360: from pay_payroll_actions ppa,
361: pay_assignment_actions paa
362: where paa.serial_number = to_char(cp_person_id)

Line 363: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

359: ppa.legislative_parameters)
360: from pay_payroll_actions ppa,
361: pay_assignment_actions paa
362: where paa.serial_number = to_char(cp_person_id)
363: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
364: ppa.legislative_parameters) =
365: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
366: ppa.legislative_parameters))
367: and paa.action_status = 'C'

Line 365: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

361: pay_assignment_actions paa
362: where paa.serial_number = to_char(cp_person_id)
363: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
364: ppa.legislative_parameters) =
365: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
366: ppa.legislative_parameters))
367: and paa.action_status = 'C'
368: and ppa.payroll_action_id = paa.payroll_action_id
369: and ppa.effective_date = cp_effective_date

Line 389: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

385: ,cp_business_group_id in number) is
386: select ppa.report_type,
387: paa.assignment_id,
388: paa.assignment_action_id,
389: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
390: ppa.legislative_parameters)
391: from pay_payroll_actions ppa,
392: pay_assignment_actions paa
393: where paa.serial_number = to_char(cp_person_id)

Line 394: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

390: ppa.legislative_parameters)
391: from pay_payroll_actions ppa,
392: pay_assignment_actions paa
393: where paa.serial_number = to_char(cp_person_id)
394: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
395: ppa.legislative_parameters) =
396: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
397: ppa.legislative_parameters))
398: and paa.action_status = 'C'

Line 396: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

392: pay_assignment_actions paa
393: where paa.serial_number = to_char(cp_person_id)
394: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
395: ppa.legislative_parameters) =
396: nvl(cp_pre_org_id,pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
397: ppa.legislative_parameters))
398: and paa.action_status = 'C'
399: and ppa.business_group_id = cp_business_group_id
400: and ppa.payroll_action_id = paa.payroll_action_id

Line 421: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',

417: and report_qualifier = 'CAEOYRL2'
418: and action_type = 'X'
419: and action_status = 'C'
420: and effective_date = cp_year
421: and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
422: legislative_parameters) = to_char(cp_pre);
423:
424: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
425: select substr(full_name,1,48), employee_number