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.HR_PRE_PAY dependencies on PAY_PRE_PAYMENTS

Line 28: (pre_payment_id pay_pre_payments.pre_payment_id%type,

24: a_action_id number
25: );
26: --
27: type pre_pay_rec is record
28: (pre_payment_id pay_pre_payments.pre_payment_id%type,
29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,
30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,

Line 29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,

25: );
26: --
27: type pre_pay_rec is record
28: (pre_payment_id pay_pre_payments.pre_payment_id%type,
29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,
30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,

Line 30: assignment_action_id pay_pre_payments.assignment_action_id%type,

26: --
27: type pre_pay_rec is record
28: (pre_payment_id pay_pre_payments.pre_payment_id%type,
29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,
30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,

Line 31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,

27: type pre_pay_rec is record
28: (pre_payment_id pay_pre_payments.pre_payment_id%type,
29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,
30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,

Line 32: value pay_pre_payments.value%type,

28: (pre_payment_id pay_pre_payments.pre_payment_id%type,
29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,
30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,

Line 33: base_currency_value pay_pre_payments.base_currency_value%type,

29: personal_payment_method_id pay_pre_payments.personal_payment_method_id%type,
30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,

Line 34: source_action_id pay_pre_payments.source_action_id%type,

30: assignment_action_id pay_pre_payments.assignment_action_id%type,
31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,
38: effective_date pay_pre_payments.effective_date%type,

Line 35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,

31: org_payment_method_id pay_pre_payments.org_payment_method_id%type,
32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,
38: effective_date pay_pre_payments.effective_date%type,
39: category pay_payment_types.category%type,

Line 36: organization_id pay_pre_payments.organization_id%type,

32: value pay_pre_payments.value%type,
33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,
38: effective_date pay_pre_payments.effective_date%type,
39: category pay_payment_types.category%type,
40: cash_rule varchar2(40),

Line 37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,

33: base_currency_value pay_pre_payments.base_currency_value%type,
34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,
38: effective_date pay_pre_payments.effective_date%type,
39: category pay_payment_types.category%type,
40: cash_rule varchar2(40),
41: payment_currency varchar2(16),

Line 38: effective_date pay_pre_payments.effective_date%type,

34: source_action_id pay_pre_payments.source_action_id%type,
35: prepayment_action_id pay_pre_payments.prepayment_action_id%type,
36: organization_id pay_pre_payments.organization_id%type,
37: payees_org_payment_method_id pay_pre_payments.payees_org_payment_method_id%type,
38: effective_date pay_pre_payments.effective_date%type,
39: category pay_payment_types.category%type,
40: cash_rule varchar2(40),
41: payment_currency varchar2(16),
42: base_currency varchar2(16)

Line 438: select pay_pre_payments_s.nextval

434: --
435: if (g_pre_payments(cnt).value <> 0
436: or g_pre_payments(cnt).category = 'MT') then
437: --
438: select pay_pre_payments_s.nextval
439: into payment_id
440: from dual;
441: --
442: g_pre_payments(cnt).pre_payment_id := payment_id;

Line 444: insert into pay_pre_payments

440: from dual;
441: --
442: g_pre_payments(cnt).pre_payment_id := payment_id;
443: --
444: insert into pay_pre_payments
445: (pre_payment_id,
446: personal_payment_method_id,
447: org_payment_method_id,
448: value,

Line 809: insert into pay_pre_payments

805: --
806: -- insert a prenote entry.
807: --
808: hr_utility.set_location('HR_PRE_PAY.VALIDATE_MAGNETIC',2);
809: insert into pay_pre_payments
810: (pre_payment_id,
811: personal_payment_method_id,
812: org_payment_method_id,
813: value,

Line 819: values (pay_pre_payments_s.nextval,

815: assignment_action_id,
816: organization_id,
817: payees_org_payment_method_id,
818: effective_date)
819: values (pay_pre_payments_s.nextval,
820: personal_method,
821: org_method,
822: validation_value,
823: 0,

Line 3381: type t_pre_payment_id is table of pay_pre_payments.pre_payment_id%type

3377: --
3378: procedure process_asg_rollup(p_assignment_action in number)
3379: is
3380: --
3381: type t_pre_payment_id is table of pay_pre_payments.pre_payment_id%type
3382: index by binary_integer;
3383: type t_assignment_action_id is table of pay_pre_payments.assignment_action_id%type
3384: index by binary_integer;
3385: type t_payroll_action_id is table of pay_payroll_actions.payroll_action_id%type

Line 3383: type t_assignment_action_id is table of pay_pre_payments.assignment_action_id%type

3379: is
3380: --
3381: type t_pre_payment_id is table of pay_pre_payments.pre_payment_id%type
3382: index by binary_integer;
3383: type t_assignment_action_id is table of pay_pre_payments.assignment_action_id%type
3384: index by binary_integer;
3385: type t_payroll_action_id is table of pay_payroll_actions.payroll_action_id%type
3386: index by binary_integer;
3387: --

Line 3404: pay_pre_payments ppp

3400: pay_payroll_actions ppa_pre,
3401: pay_assignment_actions paa_pru,
3402: pay_assignment_actions paa_pre,
3403: pay_action_interlocks pai,
3404: pay_pre_payments ppp
3405: where
3406: paa_pru.assignment_action_id = p_asg_act
3407: and ppa_pru.payroll_action_id = paa_pru.payroll_action_id
3408: and paa_pru.assignment_action_id = pai.locking_action_id

Line 3462: pay_pre_payments ppp

3458: ppp.organization_id,
3459: sum(nvl(base_currency_value, 0)) base_currency_value,
3460: sum(nvl(value,0)) value
3461: from pay_contributing_payments pcp,
3462: pay_pre_payments ppp
3463: where pcp.payroll_action_id = p_pactid
3464: and pcp.contributing_pre_payment_id = ppp.pre_payment_id
3465: group by ppp.org_payment_method_id,
3466: ppp.payees_org_payment_method_id,

Line 3469: l_pre_pay_id pay_pre_payments.pre_payment_id%type;

3465: group by ppp.org_payment_method_id,
3466: ppp.payees_org_payment_method_id,
3467: ppp.organization_id;
3468: --
3469: l_pre_pay_id pay_pre_payments.pre_payment_id%type;
3470: --
3471: begin
3472: --
3473: for totrec in get_totals(p_pactid) loop

Line 3475: select pay_pre_payments_s.nextval

3471: begin
3472: --
3473: for totrec in get_totals(p_pactid) loop
3474: --
3475: select pay_pre_payments_s.nextval
3476: into l_pre_pay_id
3477: from dual;
3478: --
3479: insert into pay_pre_payments

Line 3479: insert into pay_pre_payments

3475: select pay_pre_payments_s.nextval
3476: into l_pre_pay_id
3477: from dual;
3478: --
3479: insert into pay_pre_payments
3480: (pre_payment_id,
3481: org_payment_method_id,
3482: value,
3483: base_currency_value,

Line 3500: from pay_pre_payments ppp

3496: update pay_contributing_payments pcp
3497: set pre_payment_id = l_pre_pay_id
3498: where pcp.payroll_action_id = p_pactid
3499: and exists (select ''
3500: from pay_pre_payments ppp
3501: where ppp.pre_payment_id = pcp.contributing_pre_payment_id
3502: and ppp.org_payment_method_id = totrec.org_payment_method_id
3503: and ppp.payees_org_payment_method_id = totrec.payees_org_payment_method_id
3504: and ppp.organization_id = totrec.organization_id